• 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;-)