I've lost track of the pluses. So +57 to all of the above.

I saw that Transaction 1 had not committed, and was in a quandary. None of the answers seemed...

Thanks for the question. However, the question says CAN you restore from any of the snapshots. If I say that it is possible to restore from ANY of the snapshots,...

Thanks Christian for some useful and interesting information. And thanks to Roberto for the question. Good stuff.

Nakul Vachhrajani (7/17/2012)

---

Personally, I believe that formatting and local adjustments should be performed by the application/UI layer and not the database. Dates in the database should be stored as UTC...

Thanks for the question. There is also information on this topic in http://msdn.microsoft.com/en-us/library/ms191497(SQL.90).aspx

Edited to correct stupid tag mistake!

paul.knibbs (7/17/2012)

---

Surely adding the timezone feature mentioned by Steve would count as a "new...

Software...

Thanks for the question, which was perfect for a Monday. I must admit I hesitated before clicking the correct answer. A few recent questions have made me see conspiracies everywhere....

Lynn Pettis (7/12/2012)

---

Although I got it correct, I think the true correct answer should have been Operating System Maximum. This would have taken the version of the OS out...

Thanks to Samith for the Question and Explanation. It was only "easy" because I knew the answer. Still, not every question need be a "puzzler". It's good to have other...

Thanks Kenneth for a very good question. It was well written and explained. (Only improvement to code would be to alias computed columns.) And, with a short amount of code,...

Thanks for the question Samith. I'm guessing you specified an SQL Server version to avoid problems that occasionally pop up with QotD's that don't specify the version. In this case,...

Nice, simple, but useful question. THanks!

I almost answered the question as I first misread it:

SELECT 'A'

UNION ALL

(SELECT 'B'

UNION

SELECT 'A')

Which gives the A,A,B I almost clicked on. I have my tea...

BrainDonor (7/6/2012)

---

That explanation requires expanding slightly, because there is more than one type of temporary table.

Local temporary tables (prefixes with '#') go out of scope when the exec command...

Arriving late to the party, I noticed that everyone else was also at the wrong address.