nonghead-webspam (7/1/2014)
Reason I want to use NoLock is because queries are returning slowly. Instructions say that is what it is good for.
No.
Nolock is not a performance tuning technique. It's not there to make your queries faster and, if you have a DB that's static, it's going to have just about no effect.
Rather learn to tune your queries properly than flailing around randomly looking for a magic silver bullet that doesn't exist.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability