DataWriter

May 1, 2011

Meme Monday: I’ve Got 99 Problems…

Filed under: Uncategorized — Joe Casella @ 10:55 am
Tags:

In this month’s Meme Monday, Tom LaRock challenges us to list nine things that can go wrong with SQL that aren’t a result of disk issues.  Here are mine:

  1. Selecting from a view returns an error because an underlying table was changed.
  2. “String or binary data would be truncated” error on insert.
  3. Parameter sniffing.
  4. High CXPACKET activity because of an incorrect MAXDOP setting.
  5. Unnecessary query compilation/recompilation because code was written as Database..Table instead of explicitly specifying a schema. (e.g. Databse.dbo.Schema).
  6. Deadlocks.
  7. ODBC Timeout in the client.
  8. “Cannot generate SSPI context”.
  9. Using IDENTITY_INSERT  on an identity column creating duplicate values (because the column doesn’t have a unique constraint).
On a really bad Monday, I can probably find nine problems in ten minutes!
Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: