http://www.sqlservercentral.com/blogs/stratesql/2011/05/02/meme-monday-_1320_-_1C20_i-got-99-problems-but-a-disk-ain_1920_t-one_1D20_/

Printed 2014/04/21 04:42AM

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

By StrateSQL, 2011/05/02

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?

Related posts:

  1. #Meme Monday
  2. Webcast Next Week – Performance Impacts Related to Different Function Types
  3. Webcast Today – Performance Impacts Related to Different Function Types


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.