Myths and Misconceptions about Locking & Blocking — Klaus Aschenbrenner
Want to learn more about GroupBy’s Sponsors? Check them out below!
SolarWinds: https://loom.ly/WBIxdm0
Redgate: https://loom.ly/mWU0yLs
You know the various Transaction Isolation Levels and Locking/Blocking very well in SQL Server? If yes, come and join my session where I will talk about various Myths and Misconceptions around Locking & Blocking that I have encountered over the years. We will take a whirl tour through some edge cases that will change forever how you think about Locking & Blocking in SQL Server. During this session we will cover the following areas:
*) NOLOCK can block!
*) Shared Locks are blocking Shared Locks!
*) Read Committed behaves as Repeatable Read
*) Online Index Operations are not Online
DOWNLOAD SLIDES:
https://drive.google.com/drive/folder...