Let's don our Sherlock Holmes hat and dig into the guts of the SQL Server engine to figure out how a given trace flag works. At first we will have very little knowledge about it, but as we continue the investigation, its secrets will be revealed.

And, um, yeah, we'll need the debugger for this one.