Looks like many of us, judging from the distribution of answers, learned something today. Thanks for the question.

cfradenburg (8/9/2011)

---

Any time you see checkboxes it means there's more than one answer. When submitting a question you don't have the option of selecting radio button or checkboxes. ...

Thanks for the question.

I blew it as I thought you were looking for a single answer. A "Check all that apply" would have helped.

Tom.Thomson (8/8/2011)

---

The key to the difference in the section you quote is the phrase "leaf level" in the description for Reorganising Indexes. I'll try to explain what happens, why...

Thanks for the great question.

I thought that "Rebuilding an index drops the index and creates a new one. In doing this, fragmentation is removed, disk space is reclaimed by...

Thanks for the question. Glad it combined T-SQL with some logic. Not all questions have to have something to do with unexpected behavior/"features" of SQL Server. Once you know those...

Wait for it. There will be someone that will hold a baby coyote in their...

Carlo Romagnano (8/3/2011)

---

EXISTS check if subquery returns ROWS and does not execute EXPRESSION or read column value. So, in this case divide by zero is never executed, but ONE ROW...

Thanks for the straightforward question that I made tricky by seeing the first three bullets in the reference, eliminating those answers and deducing that the fourth choice must be correct....

Richard Warr (8/1/2011)

---

My immediate thought was:

US : 'Hello World'

Canada: 'Hello World, eh?'

quote]

Good thing I wasn't drinking anything when I read your post. It would have been a case of "and...

Just curious - what situations require replacement of CHAR(0)? How does it end up in your data? Thanks.

Ninja's_RGR'us (7/27/2011)

---

Here's another nice one : quote]

Now that was just plain beautiful!

Wait a minute, the question said "SQL Server Agent", not "Microsoft SQL Server Agent". I assumed it was referring to the Rigel 7 version of "Gornian SQL Server Agent". And...

Kiara (7/26/2011)

---

They always make me think of undersea adventure novels usually acquired in airports and read midflight in the pre-Kindle days when I'd be out of things to read... National...

Thanks for the question. NUMA questions are always fun. Just saying "NUMA" makes me smile. NUMA Thurman?