Category: Performance

• Purging a Table based on a Fixed Number of Rows to Keep

  

  2012-02-07 - Archiving and Purging, General, Performance

  Purging old data out of the database usually is driven by a date. If the business does not need records that are older than a Year, and if your records have a date column, you can purge by deleting all [more…]

• The Performance Impact of Forwarded Records on Table Scans

  

  2012-01-31 - General, Performance, SQL Server Internals

  Forwarded records are a mechanism that SQL Server employs to reduce the amount of maintenance work for indexes on a table without a clustered index. During an update of a record in a table that does not have a clustered [more…]