and then select the wrong options anyway, even though you know the...

I'm in a minority in thinking this was quite a good question.

Unfortunately ruined by the misleading title "Commenting in Dynamic query" - it's got absolutely nothing to do with...

The number of wrong answers suggests spambots may be at work 😉

Well I got it wrong, despite already using XML indexes.

I suspect this is because the question made no mention of the date format set on the database 😉

Figured they wouldn't remove functionality from a later release so guessed right 🙂

Got it wrong as there's no mention of a limit in the Primary Key or Create Table sections of BOL.

Anyone who even approaches the limit should be sent on a...

If the given 'correct' answer is actually correct (and emphatically so given that it's 5 points) then I'll have to stop answering the QotDs since my motivation is clearly wrong.

A contender for the worst QotD ever 😉

Good question - but the "explanation" is just a repetition of the answer.

I was expecting to see a 100% correct rate given that the same thing has appear a lot in QOTDs over the last few months - but currently just 60%...

Because many of us prefer to answer based on current knowledge/guesswork, and then research...

+2 !

I thought it looked familiar!

http://www.sqlservercentral.com/Questions/Tags/UNION/UNION/

I saw the film, but I think I'd gone to sleep long before it got to that bit

bitbucket-25253 (6/28/2012)

My hope is, those who complained just as you have, (or made an assumption) do not read job or project specifications at work in so careless a manner and...