Nakul Vachhrajani (2/1/2012)
SQL Kiwi (2/1/2012)
I propose to switch the answers #4 and #5. The answer All of above becomes correct in this order.
:laugh: I like it!
I like it too! 🙂
I vote for that too :). In present form, there is no right answer. This happens time to time on QotD, no big deal really thanks to the following discussions, which usually clear things out and adds learning value :).
And I'm waiting also for a post saying it depends, as e.g. index hints aren't always considered, depending on specific SET option values (see BOL on Table Hints).
(As far as my understanding of English goes this would imply that under certain circumstances a hint does not override a SET option, as the latter has to be present for the former to be considered--so there's some dependency of the hint on a specific SET option; and if the option is not set, the hint cannot override it. Am I getting too philosophical?)
Thanks for a good question and a lively discussion.