apatel62 (11/7/2012)
Deleting as fast as possible:Two suggestions 1) log(ldf) and data(mdf) files on physically separate disks.
2) Partition the table so that records to be deleted are distributed among several spindles
if possible, partition the table so that incoming data and to_be_deleted data resides on seperate partition. if you can do that just delete the partition.
+1
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)