• It's been a while, so here's a few more:

    Trace Flag: 9481

    Purpose: Use when running SQL Server 2014 with the default database compatibility level 120. Trace flag 9481 forces the query optimizer to use version 70 (the SQL Server 2012 version) of the cardinality estimator when creating the query plan.

    KB Article: http://support.microsoft.com/kb/2801413

    First Added: SQL 2014

    Versions: SQL 2014

    Trace Flag: 2312

    Purpose: Use when running SQL Server 2014 with database compatibility level 110, which is the compatibility level for SQL Server 2012. Trace flag 2312 forces the query optimizer to use version 120 (the SQL Server 2014 version) of the cardinality estimator when creating the query plan.

    KB Article: http://support.microsoft.com/kb/2801413

    First Added: SQL 2014

    Versions: SQL 2014

    Trace Flag: 101, 102

    Purpose: Troubleshoot merge replication performance issues

    KB Article: http://support.microsoft.com/kb/2892633

    First Added: SQL 2005

    Versions: SQL 2005, SQL 2008, SQL 2008 R2, SQL 2012

    Trace Flag: 849

    Purpose: SQL may display memory corruption and recovery errors

    KB Article: http://support.microsoft.com/kb/2967651

    First Added: SQL 2005

    Versions: SQL 2005, SQL 2008, SQL 2008 R2, SQL 2012, SQL 2014

    Trace Flag: 2453

    Purpose: Allows the query optimizer to use information about the number of rows inserted into a table variable in order to select more efficient query plan

    KB Article: http://support.microsoft.com/kb/2958429

    First Added: SQL 2012 SP2

    Versions: SQL 2012 SP2