chandan_jha18 (9/20/2013)
If somebody has worked in such an environment before, please give your suggestions and inputs on how to take this further.
YOu need to go with batch approach where bunch of rows get deleted . see http://www.sqlservercentral.com/articles/Top/63301/
There could be another factors which make the delettion slow like
--Foreigh key cascade deletion.
--Trigger.
--Purging the data at peak time.
--delete sql must get supported by index.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)