title: How many records can i store in a Sql server table before it's getting ugly?
body: <p>i've been asked to do some performance tests for a new system.
  It is only just running with a few client, but as they expect to grow, these are the numbers i work with for my test:</p>
  
  <p>200 clients, 4 years of data, and the data changes per.... 5 minutes. So for every 5 minutes for every client there is 1 record.
  That means 365*24*12 = 105.000 records per client per year, that means 80 milion records for my test.
  It has one FK to another table, one PK (uniqueidentifier) and one index on the clientID.</p>
  
  <p>Is this something SqlServer laughs about because it isn't scaring him, is this getting too much for one quad core 8 GB machine, is this on the edge, or.....</p>
  
  <p>Has anybody had any experience with these kind of numbers?</p>