The NOLOCK hint: we all use it sometimes, and some of us use it almost all the time. In this session Kendra Little shows three phenomena which will cause you to look differently at the NOLOCK hint. If you have two years of experience working with TSQL and database structures, this session is for you.

For more videos like this:

Kendra Little
My goal is for you to understand your SQL Server’s behavior– and learn how to change it. When I’m not figuring out the solutions to your database problems, you’ll find me at user group meetings in Portland, Oregon. I also love to draw.
Kendra Little on sabtwitterKendra Little on sablinkedin
↑ Back to top
  1. Pingback: Dew Drop – November 10, 2011 | Alvin Ashcraft's Morning Dew

  2. Pingback: Something for the Weekend – SQL Server Links 11/11/11

  3. Pingback: Be Quick About Reading The Data You Asked For | Michael J. Swart

  4. Good Video

  5. Also nolock does not avoid latches or spinlocks being taken. Now these are a lot lighter weight than locks but especially in SQL Server 2005 (Some versions) if I recall then you could get spinlock contention caused by reads, if I recall correctly, when you had too many indexes that needed to be updated in the index usage stats or recommended indexes. I can’t quite recall. Latches and spinlocks cannot be affected by the user/DBA either unless I’m missing a trick 🙂

    Good video.

  6. Thank you! Kendra, this video pointed me in the right direction with “Could not continue with NOLOCK due to data movement”. The error while running a stored procedure with nolock queries along-side partition switching jobs, a bulk insert jobs. Although these run all the time, the error popped out for the first time.

    Just another question I would like to ask, I still think, re-running the query should resolve this for me, do you think this has anything to do with consistency errors and do I need to run CHECKDB / CHECKTABLE to see if I have consistency errors, I ask this, because I read a few blogs suggesting this.

  7. awesome

  8. Interesting presentation, thank you.

  9. Hi Kendra , Could you please help me on How to solve this error ” could not continue scan with nolock ” in SQL Server 2008 R2.

  10. Really a good presentation about NOLOCK myth. Thank you!!

Leave a Reply

Your email address will not be published. Required fields are marked *