The Query Traceflag

Trace Flag Scope

SQL Server 2012 does not come up after service pack upgrade SP4

A failed SQL Server Service Pack upgrade is fixed with a trace flag.

Preparing Encryption with Trace Flags

Properly Persisted Computed Columns

Paul White walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries involving computed columns.

Trace Flag Status

Trace Flag 2389 and the new Cardinality Estimator

Erin Stellato shows the combined effect of different versions of the cardinality estimator and trace flag 2389 on an ascending key model.

Testing SQL Server Backup Performance with Trace Flag 3042

Starting with SQL Server 2008 a new feature which allowed us to create compressed backup files by pre-allocating space. This tip will look at the performance impacts of disabling pre-allocation of space using the 3042 SQL Server trace flag.

Trace Flag

Next-Level Parallel Plan Forcing: An Alternative to 8649

The trace flag 8649 is incredibly useful. Alas, the flag is undocumented, unknown, and its full impact difficult to understand. Adam Machanic presents an alternative which you might find useful.