Also it would be nice to explain what trace flags you can turn on in SQL to catch those dead of night deadlocks that sometimes occurr. I have to say though that for a newbie this is a nice article for others it is a rehash of other items they have probably seen. Get into more details about deadlocks and how to pinpoint why, where, and when they occurr.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)