Yes, though not very explicitly (at least not where I found it).

I found the answer by first realizing that the description in...

Mighty (5/21/2013)

---

Hi, this was a nice question, however I don't fully agree with the wording

SUBSTRING is still used, but...

Alex Fekken (5/18/2013)

---

I probably should have confessed earlier that neither is mine. But judging by your last...

L' Eomot Inversé (5/18/2013)

---

[Of course it's not a bug in SQL Server. It may or may not have been a bad choice in the standard or in IBM's original...

sea4stars (5/18/2013)

---

Interesting: After I decided on my answer of the first insert running ok, and the second insert failing, I fired up my trusty copy of SQL Server...

Alex Fekken (5/17/2013)

---

Nice attempt at a "proof by intimidation"...

This year's MVP Summit has already passed, and you...

KWymore (5/16/2013)

---

Nice question. Thanks Igor.

Also, thanks for the extra information Hugo! I've been considering the uses of columnstore indexes but I don't know that I would get much benefit out...

mtassin (5/16/2013)

---

I was familiar with it.... but not to the degree that I'd have even looked to see if you could use a decimal/numeric data type with a precision greater...

Raghavendra Mudugal (5/16/2013)

---

From BOL - "A table with a columnstore index cannot be updated" - seems likes the table will become as a look up table or possibly one of...

and

hany.helmy (5/15/2013)

---

In the Explanation:...

PHYData DBA (5/15/2013)

---

Thanks for clearing that up. Your wording in this QOTD, other QOTD, and your MS Connect submission comments have confused more than just one person about your opinion...

PHYData DBA (5/15/2013)

---

Nice question Hugo and valid point.

One part of your explination is very puzeling

What...

People who submit...

Thanks, all for the kind comments and the valuable discussion.

It's interesting to see how different people have different opinions about BETWEEN. In my experience, this sometimes goes wrong when variables...