Thanks for the question, I too have run into this and now know better.

As for the missing GOs I thought about that being a problem, but since you had each...

But what is the definition for...

SanDroid (11/17/2010)

---

UMG Developer (11/17/2010)

---

mtassin (11/17/2010)

---

I agree. I got this wrong for the same reason. The Row Size doesn't change, compression just lets more data be stored on a...

But in this...

Thanks for the question.

Thaks for the question.

Nice question, thanks!

Thanks for the question. I missed one of the three, so I should get 66% of a point. 😉

Thanks for the question.

One small point, not only did the create for the second table fail, so did the drop. (Though I doubt that would trip anybody up.)

I agree that the question is good, and TRUE is the correct answer. The question is "All Recovery Models support Database Snapshots." which is true, as they do. However not...

Thanks for the question.

I don't normally pay much attention to the titles, since they sometimes are designed to be misleading. But yeah, that would have given...

Nice question, I would have gotten it wrong had the option for the problem with + not been there. (I didn't see the computed column so once I went looking...

Just curious if you have an update on if the trace flag fixed the problem or if you still have random hangs.

Interesting question, I have never thought of using the DISTINCT/OVER combination instead of the standard GROUP BY to get a value.

Of course if you look at the execution plans the...