Not sure I follow the reasoning behind the correct answers. WITH CUBE returns more rows, but not WITH ROLLUP. And yet they return the same number of rows? How is...

If you look anywhere outside of the database world, I'm pretty sure you'd get a pretty unequivocal answer: You have, for example, a number of objects/structures/tuples/rows that are manifestations of...

Well, the traceflag doesn't control anything except parallelism of DBCC:

Disables parallel checking of objects by...

Nice one. I got it wrong, simply because I figured adding two dates just doesn't make any sense, and so the result should be the strings concatenated.

Bzzzt!

Interesting. However, the question doesn't actually say if those are one trillion different integers, or if there are repetitions. If there are one trillion different values, I doubt there will...

These questions certainly require a fair bit of mind reading to get "correct". But remembering the debacle from the previous installment and the following discussion, CEILING will accomplish what Steve...

Doh! I missed the "Distributed" part of the heading. There's nothing in the docs about regular replay that says anything about versions for replay targets.

Have to agree with the above. I have to admit I didn't really understand what Steve was trying to achieve, but I still got points because that was the only...

Just pitching in for #4 to get a point.