New SQLChallenge: Defuse the Deadlock

on February 20, 2018

When I first created SQLWorkbooks, I distilled what it was all about down into one sentence: “Learn SQL Server by Solving Problems.”

This month, I introduce my first SQLChallenge, which distills that down into practice. The SQLChallenge features 23 minutes of video with scripts that you can use to reproduce and solve the problem yourself.

Defuse the Deadlock

In this SQLChallenge , 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).

Additional learning

In the videos where we defuse the deadlock together, you will learn:

  • Where the graphic deadlock may contain a lie
  • Why dropping a near-duplicate index could cause a deadlock to happen

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.

What if I need to learn more?

I wouldn’t leave you without a safety net.

The SQLChallenge links you to a course which explains more of the background on what deadlocks are, how to capture deadlock graphs, and even more info on how to solve deadlocks – with a totally different deadlock example.

Even if you’ve never faced off with a deadlock before, you can solve ‘em!

SQLChallenges are now free

Check them all out here.