To some people NOLOCK is the magic turbo button that makes queries run faster, to others it means your query results are going to be incorrect.

In this talk we look at what the NOLOCK hint actually does, with lots of demo’s to illustrate some of the interesting ways it can return incorrect results.

We then move on to how optimistic concurrency can solve many of the issues that NOLOCK is often used to ‘fix’. We look at more demos to highlight some of the the common gotchas that can trip us up when implementing optimistic concurrency, and how we can avoid them.

By the end of the session attendees should have a better understanding of why we should be careful with using NOLOCK, using the transaction isolation levels that provide optimistic concurrency, and which approaches are most suitable for which workloads.
(no tags)
The video is not available to view online.