Defuse the Deadlock SQLChallenge (23 minutes)

Sharpen your skills at fighting blocking

You get:

  • Scripts and a video showing you how to reproduce the deadlock
  • A copy of the deadlock graph

Your challenge:

  • Design an index that prevents the deadlock from happening when the repro steps are run again

After you’re done working on preventing the deadlock, watch the videos showing how I strategized the solutions, and indexes I tested that prevent the deadlock (you get these, too, in the solution script).

Worried you’ll get stuck?

Getting stuck is totally OK – it’s the struggle that gets you there in the end!

If you get totally frustrated, go ahead and watch the solution videos. Then set yourself a reminder to retake the challenge in one week’s time. Running through the challenge again will lock in the learning.

Get the scripts

https://github.com/LitKnd/SQLWorkbooks/tree/main/defuse_deadlock_sqlchallenge

Modules

Menu