Comments

  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.”

    http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-(2930)-fixing-heap-fragmentation.aspx

Leave a comment

*