Meme Monday – “I got 99 problems but a disk ain’t one”

Posted by & filed under , .

1481504305_0045aac3f2_mEarlier today, Thomas LaRock (Blog | @SQLRockstar) tagged me for his Meme Monday post.  The question for today is: how many things can go wrong with a database server that are NOT related to a disk drive?  Here are my 9 items…

  1. Unchecked parallelism
  2. Unmanaged security
  3. Code that works, not performs
  4. Disbelief in clustered indexes
  5. Lack of appropriate indexes
  6. Undocumented recovery strategy
  7. Untested backups
  8. Misuse of scalar user-defined functions
  9. Overloaded, un-tuned stored procedures

My list of items are a few of the more frequent items that I’ve found while performing SQL Server assessments that I’ve done for customers.  What are your problems?

  • http://blog.realworldis.com Chris Anderson

    Given the subject line, i was expecting entries like:
    Server damaged by gunshots
    Seized by the feds
    Query not responding… until it gets its lawyer

    or for a legitimate one:
    service account disabled/deleted from active directory