Defuse the Deadlock SQLChallenge (23 minutes)
- Scripts and a video showing you how to reproduce the deadlock
- A copy of the deadlock graph
- 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.