Nice question.

Tricky though. Makes you read closely.

Interesting question. Highlights the features of two clauses- UNION & ORDER BY

but the phrasing of the question was kind of misleading. That has caused lots of folks to skip the...

Good tip. Thanks,

We can have a utility that parses the output file looking for the text - 100% loss.

That indicates that a server is not responding and if so take...

Good question.

I guess this article relates more to the question than the one posted.

http://msdn.microsoft.com/en-us/library/ms181127.aspx

Good question. Makes a good differentiation between the bit Operator XOR and the Math function POWER.

There is only one correct answer as demonstrated by Tom Garth.

Why do we allow such questions with not enough clarity?

Good Question. Table variables do not honor transaction, but are valid. This option caught me off guard.

Good question, does a good job of testing knowledge about BETWEEN,

but bad english.

I think the questioner needs to know the difference between 'consistent' and 'same as'.

Consistent means same result...