SQL Server Concise List Of Trace Flags

Question

I did my 5 minute research and have not come up with a concise list, or even a list really except for Trace Flags (2012) which is a bit lacking.

Looking at this query which uses 8691, I was wondering if such a list exists.

with cte(guid,other) as ( 
select newid(),1 union all 
select newid(),2 union all 
select newid(),3) 
select a.guid, a.other, b.guid guidb, b.other otherb 
from cte a 
cross join cte b 
order by a.other, b.other 
OPTION (QUERYTRACEON 8691);

Answer 1

http://antapex.org/traceflags_sqlserver.txt

Although this isn't complete, it is the biggest single list I know of.

This MSDN article lists the Query Optimizer Trace Flags necessary to support several changes to the QO in various QFEs and hotfixes, etc.

http://support.microsoft.com/kb/974006

Technet also has a list of various trace flags (probably already documented in the links above:

http://technet.microsoft.com/en-us/library/ms188396.aspx

This documents trace flag 610: http://msdn.microsoft.com/en-us/library/dd425070%28v=SQL.100%29.aspx (controls minimally logged inserts into indexed tables)

(more to come)

Answer 2

The list of trace flags which you found on MSDN are the only flags which you should be running.

Anything which isn't documented is only supposed to be used by the developers and PSS when troubleshooting problems.