Blog Archives

Week 6 – Database Corruption Challenge

Welcome to the Week 6 Corruption Challenge.  If you have seen the t-shirt that I designed for the winner at the end of the 10 week period, please take a look.   For this challenge, any version of SQL Server

Posted in Corruption Tagged with: ,

Slow CheckDB – What do you do?

There are many times that CheckDB ends up being extremely slow, sometimes taking more than a day to run. This can make life difficult if you are trying to find out what is corrupt. There are several of the tricks

Posted in Corruption Tagged with:

Corruption Challenge Solutions So Far

Lately several people have asked me for the solutions to the corruption challenge, so I thought it would be a good time to recap the last 5 weeks. Week 1 of the Database Corruption Challenge was won by Brent Ozar,

Posted in Corruption Tagged with:

Database Corruption Challange 6 – Coming Soon

Hello everyone, the last week I have not been able to keep everyone as up to date on the Database Corruption Challenge as I would like to. Life has just turned really busy in the last 10 days, but I

Posted in Uncategorized Tagged with: ,

Week 5 – Alternate Solution

Here is how I solved Week 5 of the Database Corruption Challenge. The following steps were tested and confirmed working on SQL Server 2008R2, SQL Server 2012, and SQL Server 2014.   To oversimplify, here are the steps: Restore the

Posted in Uncategorized Tagged with: , , , , , ,

Week 5 – Winning Solution – Database Corruption Challenge

Find out more about the Week 5 Challenge on the overview blog post. The winning solution, was submitted by Patrick Flynn, just 3 hours and 18 minutes after the challenge was posted. Patrick provided me with the following steps, and TSQL

Posted in Uncategorized Tagged with: , , ,

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at with my newsletter.
Newsletter signup form.

Stedman Solutions


Common Table Expressions Book