Defuse the Deadlock SQLChallenge (23 minutes)

Sharpen your skills at fighting blocking and index design by defusing this deadlock
Sharpen your skills at fighting blocking and index design by defusing this deadlock
See how easy it is for your users to get incorrect data under SQL Server's default isolation level - and start out on the path to fixing your queries.
Learn why Read Committed Snapshot Isolation (RCSI) and Snapshot Isolation levels are critical for scaling workloads in SQL Server.
Learn why read committed is not enough, and the tradeoffs you make if you choose serializable or repeatable read with disk based tables.
Preview this course - (1 preview lessons)
See automatic isolation level escalation in action, as we query a readable secondary in an Always On Availability Group.
What happens when you use NOLOCK hints in your code, or set your isolation level to READ UNCOMMITTED in SQL Server? Learn the dirty secrets and potential uses of NOLOCK.
Preview this course - (1 preview lessons)
Learn how to set up a free blocking monitor, how to troubleshoot live blocking with free tools, how to configure built-in tools to document blocking when it happens, and how to trace deadlock graphs in SQL Server.
Preview this course - (2 preview lessons)