Just for the record, even though it may...

L' Eomot Inversé (8/11/2012)

---

But one niggle - either the explanation is wrong about NONCLUSTERED being a mandatory keyword for CREATE COLUMNSTORE INDEX, of BoL (the page you reference in the...

SQLPhil (8/10/2012)

---

It's one of those questions where you've got to re-read the answers several times before selecting. I've come a-cropper a couple of times this week by diving in...

Good question, Pehzman. The duplicated answer in the list of answer options will probably cause some nasty comments, but since the list of answers was also included in the question...

Ken Hiatt (8/8/2012)

---

Still not believing it was that simple, I clicked Execute and got an error message stating that it couldn't find the stored procedure ISNULL. WTF There...

charles.byrne (8/8/2012)

---

L' Eomot Inversé (7/27/2012)

---

Good straightforward question.

But in the explanation: is that really the parsing order, or are you assuming that's the parsing order because it's the execution order? ...

WayneS (8/7/2012)

---

Hugo Kornelis (8/6/2012)

---

I deliberately didn't include that link, as I think the information is presented there in a very confusing...

sknox (8/6/2012)

---

Hugo, I can see why you didn't want the "choose 3" text there -- for many of us it takes a question with 31 possible answers (2^5 -1 since...

Let's just say that this is not my first QotD submission... :w00t:

By the way, the "please select 3"...

L' Eomot Inversé (8/5/2012)

---

But there is a minor error in the entence I've quoted: "at the very first microsecond" should be "in the very first 20th of a microsecond" (because...

Am I overlooking something, or has nobody yet asked the really relevant question - why would anyone put comments in dynamic SQL? They should go in the non-dynamic part of...

The question is great. But I don't really like the presentation, for two reasons:

1. The order of presentation - putting the SELECT before the CREATE TABLE and INSERT statements adds...

A late comment from me (I blame the holidays).

The only real correct answer here, as is obvious from the comments already posted, would have been "it depends".

In an ideal world,...

nerosdk71 (7/29/2012)

---

Sorry to ask a stupid question, but what will the answer be if the make the assumption that the backup that starts at 12.20 takes 15 minutes to run,...

L' Eomot Inversé (7/25/2012)

---

Hugo Kornelis (7/11/2012)

---

In my opinion, it is LEN() that has the strange behaviour here, because it returns the length of the padded version of the string instead...