About John Sansom

I’m a Microsoft Certified Master(MCM) of SQL Server. I’ve been working with database technology in a variety of flavors for over fifteen years. I absolutely love what I do and genuinely feel privileged to be a part of our tremendous technology community. Got a question about SQL Server or being a DBA? Ask me!


  1. Thanks for sharing, there are 5 & 1/2, not just 5 things!

  2. Re: 5.1
    Are you saying there’s no SQL server condition that can’t be resolved by something other than restarting SQL Server Service?

    • Thanks, John. I’ve had situations where a server was frozen and I had no alternative but to restart SQL Server Service. But as you have clarified, we couldn’t call it a fix but had to determine and fix the cause.

  3. Great list! 5.1.1 – *Rebooting* the sql server to solve issues .

  4. Mark Shay says:

    Nice Post. Where do you rank fixing heap fragmentation by creating and dropping a clustered index? I assuming top 10.

    According to the great Paul Randal, “This is just about one of the worst things you could do outside of shrinking a database.”


Leave a comment