Other Important Repositories

Official Trace Flag Documentation from Microsoft:

• Current (At this time Microsoft makes no distinction betweeen a “2014” version of the page or a “2016” version.)
• 2012
• 2008 R2
• 2008
• 2005
• TF 4199
• KB920093 (Tuning options for high-performance workloads)
• KB2801413 (Flags supported for use with QUERYTRACEON)

Print Sources:

• Kalen Delaney’s SQL Server 2008 Internals referred to in shorthand as “Kalen2008”
• Ken Henderson’s SQL Server 2005 Practical Troubleshooting referred to in shorthand as “Khen2005”.

Notable unofficial trace flag repositories:

• Technet Wiki article
• SQL Server Central
• SQL Server Central 2000 and 7.0
• SQLService.se
• Amit Banerjee
• Database-Wiki
• SQL Handle TF4199 series
• Paul Randal presentation