Month: May 2015

Database Corruption Challenge #7 Coming Soon

Those who are subscribed to my newsletter will receive the exact time of the next corruption challenge. For those who have not subscribed, just keep checking back to find out when the next Database Corruption Challenge begins. Here is the latest

Tagged with: , , ,

TSQL JOIN Types Poster (version 4.1)

After someone reported a small bug in the “two INNER JOINs” diagram, I have created an update to the poster. This is update 4.1, only a minor version upgrade due to only a small change. The thing I love about

Tagged with: , , , , , , ,

Week 6 – The Winning Solution – Database Corruption Challenge

If you are looking for more info on the corrupt database with Week 6 of the Database Corruption Challenge, you can take a look at the original post. Week 6 was won by Raul Gonzalez who submitted his winning solution

Tagged with:

A Rave from SQL Saturday Redmond

Just sharing a rave from a SQL Saturday attendee this month. I had a lot of fun with this presentation.   He was referring to the SQL JOIN Types presentation. It is just nice to get feedback like that once

Tagged with:

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

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

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,

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

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

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

Tagged with: , , ,