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?