SQL Server Trace Flags

Question

Post reply

SQL Server Trace Flags

yup

SSCarpal Tunnel

Points: 4490
More actions
June 2, 2010 at 8:16 pm

#235887

Comments posted to this topic are about the item SQL Server Trace Flags

Viewing 15 posts - 1 through 15 (of 69 total)

You must be logged in to reply to this topic. Login to reply

Chris Hamam SSC-Addicted Points: 444 More actions · Answer 1

Brillient!!!

Have been looking for a Central trace flag list for ages - and now it exists on SSC - nice one!

😀

--Chris Hamam

Life's a beach, then you DIE (Do It Eternally)

yup SSCarpal Tunnel Points: 4490 More actions · Answer 2

Be posted, I'll add a few then and now as I find and test them.

Pleasured while sharing; it will be a privilege if you can share comments for something’s missing or wrong.

David McKinney SSChampion Points: 10472 More actions · Answer 3

Thanks...looks like a very comprehensive list.

To avoid any misunderstanding, it would be good if you acknowledged your sources, when compiling your master list.

Regards,

David.

yup SSCarpal Tunnel Points: 4490 More actions · Answer 4

Will try to include that, though I'm not sure how many I can recall some of them have been taken offline.

David McKinney SSChampion Points: 10472 More actions · Answer 5

This ssc article[/url] contains a similar - but much shorter - list and refers to the Transact SQL Reference Guide - but the associated site is, indeed, offline.

Your list has all these plus much more, which for me makes it much more valuable, but if you don't attempt to quote your sources, there is the risk that it may be misconstrued. 🙂

Thanks,

David.

yup SSCarpal Tunnel Points: 4490 More actions · Answer 6

Every flag that I add/edit in my list now on will sure carry sources along with.

Promise.

philipp.katscher SSC Veteran Points: 235 More actions · Answer 7

How about this one?

DBCC TRACEON(8765)

This allows the use of variable length data, from ODBC driver.

http://bugs.mysql.com/bug.php?id=46857

So there are more undocumented ones?

How can we get a complete list of all of them?

yup SSCarpal Tunnel Points: 4490 More actions · Answer 8

Ms Support keeps on sharing a few on forums on case to case basis, other wise you may find them in personal blogs. And thanks to contributions from friends like you I'll keep adding ti my list & share them as soon as I have some weitage.

roger_os SSC Eights! Points: 831 More actions · Answer 9

roger_os

SSC Eights!

Points: 831

June 3, 2010 at 4:55 am

#1175816

This is great, thanks!

yup SSCarpal Tunnel Points: 4490 More actions · Answer 10

yup

SSCarpal Tunnel

Points: 4490

June 3, 2010 at 5:09 am

#1175823

Hey thanks man.

mrpolecat SSCertifiable Points: 7014 More actions · Answer 11

I also use 8765 knowing only that it fixes the issue of a field returning the wrong data length in ODBC. I would love to know if it effects perfomance of other queries run while it is on.