Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Does anyone have any idea what this flag does? There is no reference to it on MSDN. It is not a part of the article that lists available trace flags in 2008.

There is a KB article that recommends that it is turned on to resolve a specific issue with SQL Server 2008 that we have run into, but we would like to at least know what this flag does before enabling it.

http://support.microsoft.com/kb/960770

share|improve this question
    
Seems that it's not to be documented, like many trace flags. I left a comment on the support page. Who knows... –  splattne Jul 8 '09 at 13:35
    
I'm failing also. I left a comment, too, asking for explanation of the flag. Power in numbers, eh? –  squillman Jul 8 '09 at 13:38
    
Me too :) –  Kev Jul 8 '09 at 13:39

2 Answers 2

up vote 6 down vote accepted

I managed to get an answer to this with the help of Jonathan Kehayias on the MSDN forums.

The traceflag disables an optimization in the query optimizer. The optimization caused the issue described in the KB article when you try to insert into a table by selecting from the table itself. As turning on the traceflag could result in a perf degradation, you only should use it if you run into the issue described in the KB article.

The thread discussing this is here.

share|improve this answer
    
+1 for the follow-up. Thx! –  squillman Jul 8 '09 at 21:13
    
Top man ! –  Kev Jul 9 '09 at 11:41

At a guess, I'm thinking this turns on the hotfix included in Cumulative Update 3 should your system encounter the specific issue described in the knowledge base article.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.