title: Very large tables in SQL Server
body: <p>We have a very large table (> 77M records and growing) runing on SQL Server 2005 64bit Standard edition and we are seeing some performance issues. There are up to a hundred thousand records added daily.</p>
  
  <p>Does anyone know if there is a limit to the number of records SQL server Standard edition can handle? Should be be considering moving to Enterprise edition or are there some tricks we can use?</p>
  
  <p>Additional info:</p>
  
  <p>The table in question is pretty flat (14 columns), there is a clustered index with 6 fields, and two other indexes on single fields.</p>
  
  <p>We added a fourth index using 3 fields that were in a select in one problem query and did not see any difference in the estimated performance (the query is part of a process that has to run in the off hours so we don't have metrics yet). These fields are part of the clustered index.</p>