Myths and Misconceptions about Locking & Blocking
Details
- Online Session* Click link to join at 19:00
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 Index Operations!
About Klaus Aschenbrenner - SQLpassion
Klaus Aschenbrenner provides with his company SQLpassion SQL Server consulting & training services across Europe. Klaus works with SQL Server for more than 20 years. Klaus has also written the book Pro SQL Server 2008.
