Thanks for an interesting question. However, this may be the first time I'm satisfied with having got a wrong answer. I had the same issues with the question as did...

Unless I'm missing something, it's because you repeated the SELECT 1,'AB' three times.

(Edited to...

Hugo Kornelis (9/18/2012)

---

... This may all be due to my English reading skills (I'm not a native English speaker), but in any case, I wanted to add a comment to...

palotaiarpad (9/17/2012)

---

I guessed and won. I thought, SQL Server stores the compression flag in the header and not at the data part of the backup. And as the header remains,...

Naseer, thanks for contributing the question.

Anyone know why the SMS Take Offline command runs so slowly?

Thanks for the question. I got it right, but did so with a semi-educated guess. I reasoned that, if the answer was FALSE, this is a useless question of a...

SQL Kiwi (9/11/2012)

---

The question didn't mention trace flag 610 (which would enable minimal-logging in this scenario) so I assumed it was off, and was rewarded with a green tick and...

Thanks for the question. Went for six, as I focused on the iterations, without thinking about the select returning the just inserted rows. But, as others have said, this was...

Thanks for the great question Ron. Eagerly anticipating the follow on questions.

Think of it as an undocumented "feature". I needed the...

You overestimate how awake some of us are in...

Andrew Watson-478275 (8/31/2012)

---

It may just be an astounding coincidence, but the layout of Steve's example and the one...

Thanks for the question Hugo. I should have stretched out before running that hard early in the morning. I think I strained something! 🙂 I certainly learned something.

Thanks for the question Wayne! I don't use XML in my current work, so I had to do a bit of guessing. Went with what seemed reasonable and got it...

bitbucket-25253 (8/28/2012)

---

Hugo Kornelis (8/28/2012)

---

I've raised a documentation bug for this issue: https://connect.microsoft.com/SQLServer/feedback/details/759944/documentation-of-isdate-function-incorrect

Hugo thanks - went and voted as a bug that I could reproduce, now I wish all would do...