Common DBCC Trace Flags and their uses...

Currently enabled globally trace flags...

DBCC TRACESTATUS(-1);  

 
1117 - Grow All Files in a File Group Equally

1118 – Full Extents Only

1204 - Focused on the nodes involved in the deadlock. Each node has a dedicated section, and the final section describes the deadlock victim.

1208 - Prints the host name and program name supplied by the client. This can help identify a client involved in a deadlock

1222 - Function: Returns the resources and types of locks that are participating in a deadlock and also the current command affected

2371 - Function: Changes the fixed auto update statistics threshold to dynamic auto update statistics threshold.
Note: Beginning with SQL Server 2016 this behavior is controlled by the engine and trace flag 2371 has no effect.

4199 - Function: Enables query optimizer (QO) changes released in SQL Server Cumulative Updates and Service Packs.

8649 - Run Query Parallel