Welcome to MSDN Blogs Sign in | Join | Help

News

  • Visit the SQL Server Best Practices site (http://sqlcat.com) for real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level.

February 2007 - Posts

Previously committed rows might be missed if NOLOCK hint is used
I received a question from one of our customers about using the NOLOCK hint: can it cause missing rows in scans even if the rows were committed well before my SELECT with NOLOCK starts? The NOLOCK hint is employed by many users to avoid contention on Read More...
Posted: Thursday, February 01, 2007 7:05 PM by LuborK | 8 Comments
Page view tracker