grahamc (3/2/2011)
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.
exactly what I did 🙂
Exactly what I nearly did. Except I didn't know if it had been enabled or not, so chose the second option. Oops.
Nice question though.