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

  2. Carl Grant says:

    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?

    • Carl Grant says:

      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