Koen Verbeeck (3/2/2011)

---

Great question, thanks.

I could deduce the correct answer since I ran the query on my development machine.

Not all results were zero and the columns aren't nullable, so there were two options left.

I have never had resource governer enabled, so I chose the 3rd option, which was the correct one.