Nice question. Thanks Ron.

Nice simple question. Thanks Steve.

This is a good example of why you should always specify length for your datatypes when applicable.

Nice question, thanks!

Nice question Dwain. Datetime questions are always helpful as it seems that so many systems treat dates differently.

Nice question! Glad I had my coffee first!

Nice question, thanks Jason.

I almost chose answer 2 but upon re-reading it realized that the identity insert syntax was wrong. I never use INSERT INTO <table> DEFAULT VALUES but still got it through...

Thanks for the back to basics question Amit!

I shouldn't try to answer the QOTD when I have been working for 15 hours. Nice question Lokesh!

L' Eomot Inversé (9/21/2012)

I used sp_who2 ages ago, and wrote a thing to replace it because sp_who2 didn't do quite what I wanted in some cases (I can't remember what...

Nice question. Thank you Naseer.

Good question. I don't use tablesample so its behavior was new to me.

Thanks for the question

+1 I usually use the kill command. I will keep this option in mind though. 🙂