Good question indeed. I should have spotted that the aggregates will fail due to untyped NULL. If the null value in the last statement were typed, it would work just...

Wrong answer marked as correct. SQL Server will return the following error message:

Msg 102, Level 15, State 1, Line 5

Incorrect syntax near ';'.

Semicolon is not allowed after go.

Well, this question definitely has more than one correct answer. If you look at the actual execution plan, the correct answer is 0.

Raid 1+0 and 0+1 isn't even identical in performance, 1+0 performs better when the array is degraded.

It appears that this article has been changed (or at least republished). Perry Whittle's comment should have been taken into consideration, the difference between RAID 1+0 and 0+1 is indeed...

I think this modification does the trick:

exec(@dbName + replace(@tempSQL,'''',''''''))

If it were different in two...

Place the mouse pointer of the the file's tab.

The query will return rows anyway, otherwise temporary objects would not have worked very...

sknox (9/19/2012)

---

Another QotD which does not test what it purports to test.

Even if you know TABLESAMPLE inside and out, you cannot expect to get this question correct without knowing...

Just to make a short comment. I do not completely disagree with you. It is documented that the...

Evgeny Garaev (9/18/2012)

---

Percentage is very low for that sample data, it will likely never return any row. Change the query like that to be fair:

create table #Test (ID int primary...

In most scenarios, I would say that both should fail as SQL Server does/should not have access to create files on the system drive, but that is a different scenario...

Another reference: The -c parameter of sqlcmd.

Good question, as others I overlooked the zero and hence got it wrong.