Mahesh Bote (10/12/2012)
[font="Verdana"]one delete statement, its causing major blocking.[/font]
Why ? is it deleting the high volumned data here ?
Mahesh Bote (10/12/2012)
[font="Verdana"]While investigation for the possible optimization, I could found only one area where I was thinking to introduce Explicit Transaction for Delete statement.[/font]
certainly NOT
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)