Myths and Misconceptions about Locking & Blocking

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!