A good question about a common misunderstanding. The number of times when a problem posted to usenet or forums could be solved by simply adding the length to a varchar...

Jeff Moden (7/18/2010)

---

Hugo Kornelis (7/17/2010)

---

Jeff Moden (7/16/2010)

---

Nice job, Sunil. I especially liked the fact that you compared what some folks go through with multiple queries (in one form or...

Jeff Moden (7/16/2010)

---

Nice job, Sunil. I especially liked the fact that you compared what some folks go through with multiple queries (in one form or another) and the simplicity...

Sankar Reddy (7/15/2010)

---

[font="Courier New"]I am glad this QoD has helped people learn new things. The credit should directly go to Hugo Kornelis for his excellent feedback otherwise this would have...

If you use GROUP BY Product_Name,Scheme_Name WITH ROLLUP (sorry for using the deprecated syntax; I don't have a Books Online 2008...

Carlo, you are missing an impportant point in your repro.

The performance difference in the question is not caused by rebuilding or converting the table contents, but by rebuilding / converting...

As far as I can see, there wasn't. Semicolonms in subqueries have never been and will...

michael.kaufmann (7/13/2010)

---

jcrawf02 (7/2/2010)

---

Not sure why this one is tripping folks up, if you just count the delimiters, you can see it will return 13 pieces?

...anyway...good question, I'm sure it's introduced...

Tom Garth (7/13/2010)

---

I got it right for the wrong reason. I didn't notice the semi-colon, and since A. would not have been a complete answer, I chose C. which amounted...

Good article, andd good addition by R.P.Rozema.

Remember that WITH ROLLUP is deprecated as of SQL Server 2010. It has been replaced with GROUPING_SETS.

I got it wrong too. I was looking at the logic of the query and the subquery, not at all the fine punctuation details.

Learned nothing from this question. This is...

The explanation posted by Arto is almost correct, but not entirely.

The inner expression ('abcd'+NULL+1) is evaluated left...

wware (7/7/2010)

---

I must be missing something. In Hrvoje's example, I understand why there are no rows in #t but I don't understand why the 'A' row isn't in @t....

I...

The CASE expression (sorry about that, couldn't resist) -or rather the nested CASE expressions- are,...