• subbareddy542 (1/24/2013)


    nolock option it good for reading data.

    What???????? NOLOCK option is not always good for reading data.

    Do you understand the problems that NOLOCK give you?

    Before you start putting query hints on your code, you could tune your code and analyse why it isnt functioning without the hint.