steven.ensslen (11/6/2013)
They need a more complex solution that does less IO and doesn't put pressure on their transaction log.
IF you handle the records in bunches .. it will take care of IO plus transaction log management. thats the reason i recommended you "Batch approach deletion".
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)