Product has been added to your cart.

01 – How NOLOCK Can Show Incorrect Results (10m)

You might have heard that using NOLOCK in your queries gets you dirty reads – but what does that mean, exactly? Watch as a simple COUNT(*) query produces wildly different results when NOLOCK is used. Demo script: Transact-SQL /* How NOLOCK Can Show Incorrect Results v1.2 – 2019-07-31 Performance Tuning in 21 Demos: https://www.BrentOzar.com/go/21demos This…

To access this incredible, amazing content, you gotta get Recorded Class Season Pass, or log in if you already shelled out the cash.

  1. Home
  3. SQL Server Training Classes by Brent Ozar
  5. Performance Tuning in 21 Demos
  7. 01 – How NOLOCK Can Show Incorrect Results (10m)
You might have heard that using NOLOCK in your queries gets you dirty reads – but what does that mean, exactly? Watch as a simple COUNT(*) query produces wildly different results when NOLOCK is used. Demo script: Transact-SQL /* How NOLOCK Can Show Incorrect Results v1.2 - 2019-07-31 Performance Tuning in 21 Demos: https://www.BrentOzar.com/go/21demos This...
To access this incredible, amazing content, you gotta get Recorded Class Season Pass, or log in if you already shelled out the cash.