Trace flag in SQL server sets the specific characteristic of the server. It works as an "IF" condition for the SQL Server. The most common trace flags used with SQL Server are :
* Deadlock Information : 1204, 1205, 1222
* Network Database files : 1807
* Log Record for Connections : 4013
* Skip Startup Stored Procedures : 4022
* Disable Locking Hints : 8755
* Do Force uniform extent allocations instead of mixed page allocations 1118 (SQL 2005 and 2008).
