Sometimes the questions are built on such 'mistakes' like this ALTER/CREATE PROCEDURE. Now it's a 'you should know that it's only meaningless failure'.

How can we decide which option to use?...

Actually the default answer is the only right answer: It depends.

You can't answer the question without knowing the data it is running on.

I got the right answer, but please stop questions about CASE having really nothing to do with CASE itself! Or is QOD about fooling us around?

May i get my point, please?:doze:

Nice question, but the title is missleading. It isn't about the case and sum, but the union without all keyword.

Is BOL scrappy?

Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary...

I'm also caugth by the Extent owner case. Maybe next time you should write "might" instead of "can".

And yes, they choose the easy way. Edited the question from nvarchar to nchar.

A very sad thing.

4, 4, 4! I claim my point! 😛

Thanks!

Does this not mean:

This view will eventually replace the fn_virtualservernodes function which will be deprecated in a future release

that the correct answer is the sys.dm_os_cluster_nodes view?

It's a completely wrong implementation of this question. :angry:

It's a good question, but maybe next time you should take a notice: using Server 2005 and above.

My point of view 'does mean' and 'does equal to' aren't the same. NULL mean NULL, but equals to UNKNOWN. Bad question.