SQLBits 2011

READPAST & Furious: Transactions, Locking and Isolation

In this session we will investigate SQL Server concurrency and reveal some very surprising and thought provoking behaviors.
Do you really understand SQL Servers’ Concurrency behavior?
Do you really believe that Transactions are an ALL or NOTHING operation?
Do you really think that Read operations cannot start a Transaction?
Do you really know that READ_UNCOMMITTED is safe for reporting?

I look forward to you joining me in this very revealing and thought provoking session where I will provide answers to those questions and more and will make you wish you had known about all of this sooner.