Locking

Course Category: Locking

• Read Committed Snapshot and Snapshot Isolation (46 minutes)

  5 Lessonsin Locking

  

  Learn why Read Committed Snapshot Isolation (RCSI) and Snapshot Isolation levels are critical for scaling workloads in SQL Server.

• Read Committed is Bonkers - Webcast Recording (46 minutes)

  4 Lessonsin Locking

  

  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.

• Snapshot Isolation Against Availability Group Secondaries (28 minutes)

  3 Lessonsin Locking

  

  See automatic isolation level escalation in action, as we query a readable secondary in an Always On Availability Group.

• Defuse the Deadlock SQLChallenge (23 minutes)

  3 Lessonsin Locking, SQLChallenges

  

  Sharpen your skills at fighting blocking and index design by defusing this deadlock.

• The Dirty Secrets of NOLOCK (50 minutes)

  10 Lessonsin Locking

  

  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.

• Repeatable Read and Serializable Isolation Levels (45 minutes)

  7 Lessonsin Locking

  

  Learn the tradeoffs you make if you choose serializable or repeatable read with disk based tables.