I always put forth extra effort to "Prove" that I'm not wrong! After all POINTS are everything.

I tested it as well and what "Books Online" says is not what actually happens. The question should be rephrased to state "What Books Online says", because what really happens...

Your right, I found it in BOL! The two statements in BOL don't seem to agree.

I don't feel the 'Witness' alone can initiate a failure.

By making the disk resource a dependency, in itself, doesn't do it either. It's the combination of the two.

The answer is pretty vague. There could be two possible answers.

You also need to take the SQL Server cluster resource offline and back online for SQL to...

Thanks!

When MyID is a varchar or char, answers 1, 3 and 4 all return the correct answer of...

1;2;3;4;5;

Where in the question does it require MyID to be numeric?

Points...

Always Say NO to Atomicity!

Sorry, couldn't help but to post an ACID/Say No joke!

I agree with Kelvin about the ANSI_NULLS. I believe the ANSI_NULLS setting should stay in the MS default setting (at least since SQL 7.0), which is ANSI_NULLS ON. If stored...

Mah expertise is in 'puters. Pleaze don't discriminate!

MS chose the "default setting" to be 64Kb. Your correct the "default" maximum configurable size of 2GB isn't an option.

Did you mean "Duh" Fault?

I read the question and did not ignore the word "default". Looking at AJ's settings as most peoples settings by "default" the maximum is 2147483647 or 2GB.

However, the current...

Trick questions suck! Most of us know the answers, but give up points due to not spending enough time analysing the question for any trick phrases.

So far .4% chose STDEVP, which was from the previous question. HAHAHA!