Agree with many posts here. Interesting idea, but not correct implementation of the question and options.

This is my result (SQL 2012, master database) 6 DIFFERENT results:

(No column name)

0.713591993212924

0.713591993212924

0.713591993212924

0.713647892126698

0.713647892126698

0.713647892126698

0.713647892126698

0.713722424011731

0.713722424011731

0.713722424011731

0.713722424011731

0.713722424011731

0.713722424011731

0.713722424011731

0.713852854810538

0.713871487781797

0.713871487781797

0.713908753724313

0.713908753724313

0.713908753724313

I believe that...

Chris Harshman (7/9/2014)

I agree... I see we're back to trying to read Andy's mind to determine what he really wanted...

Interesting question, thanks Tom. Unfortunately, none of the answers are correct. Enterprise, Standard, and I assume Developer editions. This feature is only available for 64-bit SQL Server.

http://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

Thanks for the interesting question. I ran query several times on SQL 2012; output was 0 or 5 rows, but once 4 rows were returned.

Something is incorrect with the question or answer.

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

The question is: "Which of the following hints require the word WITH? (choose 3) Assume SQL Server 2012.". -

The correct...

I concur with kapil190588 that the version should somehow be mentioned.

Please see http://msdn.microsoft.com/en-us/library/ms142551(v=sql.90).aspx - noise-word list (LIST!)