SQL Server 2005 Trace Flags FAQ

Trace Flags of SQL Server 2005 are a interesting topic. Even though Developer may not be using them much, Administrators and Performance tuning engineers regularly work them. Lets find out what are Trace Flags. 1. What are Trace Flags and why are they used? 2. What are the different types of Trace Flags? 3. What is the difference between Global Trace Flag and Session Trace Flag? .....