Guessed right, YUHU!

Good explanation here: http://blogs.msdn.com/b/sqltips/archive/2008/06/26/differences-between-isnull-and-coalesce.aspx

Got it wrong, because I thought it is a trick question since "GO;" will throw an error and the table will not be created.

Found the right answer by accident, because I wasn't sure about what company Micrisoft is :hehe:

Ah, I see, looked at the wrong SQL-Server version.

Is the "no repair" answer correct?

http://msdn.microsoft.com/en-us/library/aa258278%28SQL.80%29.aspx

says:

REPAIR_FAST Performs minor, nontime-consuming repair actions such as repairing extra keys in nonclustered indexes. These repairs can be done quickly and without risk...

Find some thoughts about this topic here:

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/6002f5a4-19a0-4a11-a569-e112375d3efa/

Interesting question, but the code itself is valid. The answer you classified as correct depends on the actual data. It appears reasonable to imply that c.IsInsuranceLength is set to 1...

Great question, but the answer is language dependant since outside the us at first glance '01-08-2011' reads 1st of August 😉

In SQL 2008 the script return 'that'. But the link point to an SQL 2000 document. Behavior might have changed...

Wait! Doesn't that mean, the answer 'that' is wrong, since it...

Database Snapshots are only available in Datacenter + Enterprice Edition, not in Standard ( http://msdn.microsoft.com/en-us/library/cc645993.aspx)

Interesting question. I relied on another block http://sqlfool.com/2009/04/page-splitting-rollbacks/ which says the opposite.

Actually none of the proposed answers is correct, since the question states "...and at 10:00am on 2011/05/01...". None of the answers has the year 2011 in them...:w00t:

According to http://msdn.microsoft.com/en-us/library/ms176098.aspx this function is deprecated. And since the question did not mention Sql Server 2000 I would say, the correct answer is the last one which...

Doesn't explain why chr(13) is numeric... what function. Nice question.