Nice question and good explanation.

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...

Like Hugo, I think the question would have been better if worded differently (perhaps not quite so differently as to miss out the 2GB option for SQL 2005, though -...

Jeff Moden (8/10/2012)

---

You're spot on with the explanation of the surrogate key needing to change if two companies merge. However, I believe that just about any natural key that...

Jan Van der Eecken (8/11/2012)

---

Coming back to the picture that was pulled due to being politically inacceptable. Could whoever posted it there please send me a PM with the link...

Lynn Pettis (8/10/2012)

---

Natural keys vs Surrogate keys is one example. I have worked with a database that was designed wrong. But I had to work with what was...

Lynn Pettis (8/10/2012)

---

Okay. Just let off a little rant to Mr. Celko again. Please, if anyone thinks I went too far (and no, you'll have to find it...

No need to apologise for the delay- no-one...

GSquared (8/8/2012)

---

I'm sure I can easily get quite a bit more verbose than a phone book. Hyperloquacity is one of my specialities. Along with paragraphs that are WAY...

The thing that worries me about some of the answers is the game of always asking for test data and expected results even when the question is clear and unambiguous...

marlon.seton (8/10/2012)

---

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

---

Now why on earth anyone would want to put comments in dynamic SQL is beyond me. Its hard enough getting all the little ' right and...

Yes, Tommyh raised that question on...

Hugo Kornelis (8/4/2012)

---

Or in human people languages, all orders placed at any time on dates from July 1st up to and including July 30, plus orders placed at the very...

Raghavendra Mudugal (8/4/2012)

---

Hello; nice question indeed.:-)

.....

.....

I see now the size is increased by 5 chars in each and the result is "1,0,1,0".

But in the SQL 2000 the interpretation is different...

WayneS (8/3/2012)

---

I'm curious... how many Threadizens here would be interested in forming a QotD team to verify the questions? I'm thinking that if we can get 10 folks, that would...

bitbucket-25253 (8/3/2012)

---

A. I consider the QOD...