[dba-SQLServer] NoLocks

David Emerson newsgrps at dalyn.co.nz
Tue Feb 10 17:38:57 CST 2009


I have a sproc that runs slow due to the large number of sub 
processes it goes through.

I was wondering what potential problems I could have if I used 
NoLocks in the select statements.  The data that is being processed 
is not likely to change during running the sproc (famous last words).

Any comments?




More information about the dba-SQLServer mailing list