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