Home Forums SQL Server 2008 SQL Server 2008 Administration Efficient Data Deletion Method and Transactional Databases RE: Efficient Data Deletion Method and Transactional Databases
MysteryJimbo
SSC-Insane
Points: 24203
More actions
December 20, 2011 at 6:01 am
#1423584
The most efficient way to do mass deletions is to introduce a sliding window partitioned table setup.
This would allow you to switch out whole days of data with out meta data changes and allow you to drop the table you switched the partition into.