First published on MSDN on Feb 07, 2013
I just wanted to put a quick note that
QUERYTRACEON
is now publically documented in
http://support.microsoft.com/kb/2801413/en-us
. If you have situations where you don’t want to enable an optimizer trace flag globally on your server instance, you can use this hint for a specific query. Note that we only support the trace flags listed in the KB article.