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 ...read more