I feel disgusting, flogging such a long-dead horse, but I can't resist:

The accuracy of the answer does not depend...

This is actually much cooler than it looks - a poster above noted this but I did not understand until I tested...

If you specify a column alias that matches...

For SQL Server 2000, none of the answers are quite correct, because the closest answer (A) misses the fact that the column is not just at the start, but also...

Thanks GSquared - this makes sense to me.

I don't think I agree about the clarity of using CTEs for derived tables, but I guess that might be because I...

I see the value of CTEs, but I'm not sure I agree with the example... wouldn't it be better written (more efficient?) using a single aggregate query and a TOP...

the question could possibly be more interesting (at least to some readers) if the result of the division was not so obviously an integer, eg:

select 25 / 6 + 6...

This is a brilliant concept, and I'm amazed I have not seen it anywhere else!

There are some known issues with full-text search:

- when searching, you need to look for...

incidentally, not having the sponsored book, I was using this as reference:

http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx#EXIAG

OK, I'm a little confused... does an "IN" clause with only a single argument not count as an "IN" clause for the purposes of auto-parameterization? I got the answer right...

The "Right" answer is apparently a little misleading here... According to BOL, there would be entries in the DMV, they would just have all counters set to 0.

http://msdn2.microsoft.com/en-us/library/ms188755.aspx

Effectively, this...

Hi,

I'm a latecomer to the party and didn't realize there had already been healthy debate, but here's what I came up with.

Looking through the previous submissions above, it's the same...

Not just you.

As far as I can tell, the "Question of the Day" has gone all to pot in the last week or two. I'm giving it a break...