March 9, 2011 at 9:51 am
we have stored procs set to read uncommitted. So does mean that all the selects inside that proc are equivalent to using nolock hint? Should i mention nolock hint again in my proc on selects?
March 9, 2011 at 9:54 am
Read uncommitted is the same as setting nolock for all queries in the proc, yes. You do not need to specify it again.
March 9, 2011 at 9:58 am
Yes. thanks i got my answer here on a different post.
http://www.sqlservercentral.com/Forums/Topic720642-338-2.aspx
March 9, 2011 at 10:52 am
Happy with all the effects of read uncommitted?
See - http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply