SQL Server Trace Flags - Complete list

Question

SQL Server Trace Flags - Complete list

Viewing 15 posts - 16 through 30 (of 39 total)

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

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 1

admin 31599 - Wednesday, March 1, 2017 10:14 PM
Link to github seems to be broken.
But the one you posted in this thread is Ok.
Thanks!

Great thanks for feedback. I edit article to fix broken link and add some info in thanks to section.

steinar.andersen@sqlservice.se Valued Member Points: 70 More actions · Answer 2

kast218 - Thursday, March 2, 2017 12:46 AM
admin 31599 - Wednesday, March 1, 2017 10:14 PM
Link to github seems to be broken.
But the one you posted in this thread is Ok.
Thanks!
Great thanks for feedback. I edit article to fix broken link and add some info in thanks to section.

kast218 - Wednesday, March 1, 2017 8:07 AM
Ed Wagner - Sunday, February 26, 2017 4:44 PM
That's quite a list - and very useful. I especially like the links for more information on each one. Thanks for posting it.
Thanks for feedback!

It's a nice list, and pretty much a direct ripoff of my blogpost here http://www.sqlservice.se/updated-microsoft-sql-server-trace-flag-list/

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 3

steinar.andersen@sqlservice.se - Friday, March 31, 2017 1:59 AM
kast218 - Thursday, March 2, 2017 12:46 AM
admin 31599 - Wednesday, March 1, 2017 10:14 PM
Link to github seems to be broken.
But the one you posted in this thread is Ok.
Thanks!
Great thanks for feedback. I edit article to fix broken link and add some info in thanks to section.
kast218 - Wednesday, March 1, 2017 8:07 AM
Ed Wagner - Sunday, February 26, 2017 4:44 PM
That's quite a list - and very useful. I especially like the links for more information on each one. Thanks for posting it.
Thanks for feedback!
It's a nice list, and pretty much a direct ripoff of my blogpost here http://www.sqlservice.se/updated-microsoft-sql-server-trace-flag-list/

Initially, as a basic list, I used the wonderful article Yusuf Anis SQL Server Trace Flags (http://www.sqlservercentral.com/articles/trace+flags/70131/), then I found your post from which I made a single compilation with Yusuf Anis list. But most of the information I picked up in the excellent post Aaron Morelli A Topical Collection of SQL Server Flags (https://sqlcrossjoin.wordpress.com/2013/10/28/a-topical-collection-of-sql-server-flags/). All sources used by me are indicated in the Source Link and Thanks To section: https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md

For 1.5 years, a huge amount of work was done to refine the 3 lists in a single document: hundreds of typos and broken links have been corrected, new information were added. Starting from 2015-11-02, 30 commits were made on this file, some of them took more than 2 hours of work, and in total time costs amounted to about 50 hours (https://github.com/ktaranov/sqlserver-kit/commits/master/SQL%20Server%20Trace%20Flag.md?after=34839581ca0a9ba5291de3da960bb310a39aaad0+34). Great thanks to Alexander Titenko for awesome help in this.

Yes, your list has also been used and this fact is reflected in the thank you section and in the recommended links. But do simple arithmetic calculations: there are only 176 flags in your list, 511 in github list! If you think that I violated your intellectual property rights in any way, you can get an issue on Github (https://github.com/ktaranov/sqlserver-kit/issues).

I didn't try to reduce your contribution to the creation of the final list - your post is very good, but I'm very sorry for the colossal work (which I also put in public under the MIT license, i.e. anyone can make their version, or Improve existing) I get accused of stealing and plagiarism.

steinar.andersen@sqlservice.se Valued Member Points: 70 More actions · Answer 4

kast218 - Friday, March 31, 2017 2:38 AM
steinar.andersen@sqlservice.se - Friday, March 31, 2017 1:59 AM
kast218 - Thursday, March 2, 2017 12:46 AM
admin 31599 - Wednesday, March 1, 2017 10:14 PM
Link to github seems to be broken.
But the one you posted in this thread is Ok.
Thanks!
Great thanks for feedback. I edit article to fix broken link and add some info in thanks to section.
kast218 - Wednesday, March 1, 2017 8:07 AM
Ed Wagner - Sunday, February 26, 2017 4:44 PM
That's quite a list - and very useful. I especially like the links for more information on each one. Thanks for posting it.
Thanks for feedback!
It's a nice list, and pretty much a direct ripoff of my blogpost here http://www.sqlservice.se/updated-microsoft-sql-server-trace-flag-list/
Initially, as a basic list, I used the wonderful article Yusuf Anis SQL Server Trace Flags (http://www.sqlservercentral.com/articles/trace+flags/70131/), then I found your post from which I made a single compilation with Yusuf Anis list. But most of the information I picked up in the excellent post Aaron Morelli A Topical Collection of SQL Server Flags (https://sqlcrossjoin.wordpress.com/2013/10/28/a-topical-collection-of-sql-server-flags/). All sources used by me are indicated in the Source Link and Thanks To section: https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md
For 1.5 years, a huge amount of work was done to refine the 3 lists in a single document: hundreds of typos and broken links have been corrected, new information were added. Starting from 2015-11-02, 30 commits were made on this file, some of them took more than 2 hours of work, and in total time costs amounted to about 50 hours (https://github.com/ktaranov/sqlserver-kit/commits/master/SQL%20Server%20Trace%20Flag.md?after=34839581ca0a9ba5291de3da960bb310a39aaad0+34). Great thanks to Alexander Titenko for awesome help in this.
Yes, your list has also been used and this fact is reflected in the thank you section and in the recommended links. But do simple arithmetic calculations: there are only 176 flags in your list, 511 in github list! If you think that I violated your intellectual property rights in any way, you can get an issue on Github (https://github.com/ktaranov/sqlserver-kit/issues).
I didn't try to reduce your contribution to the creation of the final list - your post is very good, but I'm very sorry for the colossal work (which I also put in public under the MIT license, i.e. anyone can make their version, or Improve existing) I get accused of stealing and plagiarism.

You know what? You are right. I was too fast in judging you. I just found this article, and on the surface it looked just like a copy of mine. But as you say, you have added a lot to the total list, nice job!

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 5

steinar.andersen@sqlservice.se - Monday, April 3, 2017 6:23 AM
kast218 - Friday, March 31, 2017 2:38 AM
steinar.andersen@sqlservice.se - Friday, March 31, 2017 1:59 AM
kast218 - Thursday, March 2, 2017 12:46 AM
admin 31599 - Wednesday, March 1, 2017 10:14 PM
Link to github seems to be broken.
But the one you posted in this thread is Ok.
Thanks!
Great thanks for feedback. I edit article to fix broken link and add some info in thanks to section.
kast218 - Wednesday, March 1, 2017 8:07 AM
Ed Wagner - Sunday, February 26, 2017 4:44 PM
That's quite a list - and very useful. I especially like the links for more information on each one. Thanks for posting it.
Thanks for feedback!
It's a nice list, and pretty much a direct ripoff of my blogpost here http://www.sqlservice.se/updated-microsoft-sql-server-trace-flag-list/
Initially, as a basic list, I used the wonderful article Yusuf Anis SQL Server Trace Flags (http://www.sqlservercentral.com/articles/trace+flags/70131/), then I found your post from which I made a single compilation with Yusuf Anis list. But most of the information I picked up in the excellent post Aaron Morelli A Topical Collection of SQL Server Flags (https://sqlcrossjoin.wordpress.com/2013/10/28/a-topical-collection-of-sql-server-flags/). All sources used by me are indicated in the Source Link and Thanks To section: https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md
For 1.5 years, a huge amount of work was done to refine the 3 lists in a single document: hundreds of typos and broken links have been corrected, new information were added. Starting from 2015-11-02, 30 commits were made on this file, some of them took more than 2 hours of work, and in total time costs amounted to about 50 hours (https://github.com/ktaranov/sqlserver-kit/commits/master/SQL%20Server%20Trace%20Flag.md?after=34839581ca0a9ba5291de3da960bb310a39aaad0+34). Great thanks to Alexander Titenko for awesome help in this.
Yes, your list has also been used and this fact is reflected in the thank you section and in the recommended links. But do simple arithmetic calculations: there are only 176 flags in your list, 511 in github list! If you think that I violated your intellectual property rights in any way, you can get an issue on Github (https://github.com/ktaranov/sqlserver-kit/issues).
I didn't try to reduce your contribution to the creation of the final list - your post is very good, but I'm very sorry for the colossal work (which I also put in public under the MIT license, i.e. anyone can make their version, or Improve existing) I get accused of stealing and plagiarism.
You know what? You are right. I was too fast in judging you. I just found this article, and on the surface it looked just like a copy of mine. But as you say, you have added a lot to the total list, nice job!

Thanks for feedback and for your article.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

While it is a rather comprehensive list, there are some undocumented Trace Flags missing. Maybe a change in title would be appropriate?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 7

SQLRNNR - Monday, April 3, 2017 12:23 PM
While it is a rather comprehensive list, there are some undocumented Trace Flags missing. Maybe a change in title would be appropriate?

I will update title on holidays to: SQL Server Trace Flag List (with new 9939 flag)

Also, if you find some new flags or typos in this list be free create issue or just post it here.

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 8

Add new 7 trace flags - now 518. Update some info and fix broken links, add new links.

gladchenko-495957 SSC Enthusiast Points: 162 More actions · Answer 9

??????, ????? 9806, 9807 ? 9808 ?????????? ????? ?????????? ? ????????? ??????? ????? -? (??????? ????????? ?????? ?????????? ???????? ??????????? ? ???????? ??????????????????).

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 10

gladchenko-495957 - Friday, September 15, 2017 5:30 AM
ÐŸÐ¾Ñ…Ð¾Ð¶Ðµ, Ñ„Ð»Ð°Ð³Ð¸ 9806, 9807 Ð¸ 9808 Ð¿Ð¾ÑÐ²Ð»ÑÑŽÑ‚ÑÑ Ð¿Ð¾ÑÐ»Ðµ Ð´Ð¾Ð±Ð°Ð²Ð»ÐµÐ½Ð¸Ðµ Ð² Ð¿Ð°Ñ€Ð°Ð¼ÐµÑ‚Ñ€Ñ‹ Ð·Ð°Ð¿ÑƒÑÐºÐ° Ñ„Ð»Ð°Ð³Ð° -Ñ… (ÐºÐ¾Ñ‚Ð¾Ñ€Ñ‹Ð¹ Ð²Ñ‹ÐºÐ»ÑŽÑ‡Ð°ÐµÑ‚ Ð¼Ð½Ð¾Ð³Ð¸Ðµ Ð²ÑÑ‚Ñ€Ð¾ÐµÐ½Ð½Ñ‹Ðµ ÑÑ€ÐµÐ´ÑÑ‚Ð²Ð° Ð¼Ð¾Ð½Ð¸Ñ‚Ð¾Ñ€Ð¸Ð½Ð³Ð° Ð¸ ÑÑ‡Ñ‘Ñ‚Ñ‡Ð¸ÐºÐ¸ Ð¿Ñ€Ð¾Ð¸Ð·Ð²Ð¾Ð´Ð¸Ñ‚ÐµÐ»ÑŒÐ½Ð¾ÑÑ‚Ð¸).

jobbish SSC Journeyman Points: 81 More actions · Answer 11

Trace flag 692 is documented here: https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-traceon-trace-flags-transact-sql
Trace flag 9448 disables the referential integrity operator and is mentioned here: https://orderbyselectnull.com/2017/12/05/the-referential-integrity-operator/

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 12

jobbish - Monday, December 4, 2017 10:21 PM
Trace flag 692 is documented here: https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-traceon-trace-flags-transact-sql
Trace flag 9448 disables the referential integrity operator and is mentioned here: https://orderbyselectnull.com/2017/12/05/the-referential-integrity-operator/

jobbish thank you very much for this info, updated via https://github.com/ktaranov/sqlserver-kit/commit/d2a1b366123ae249b49a1cbbc58ab480a5492687
Also update article here, waiting for re-publication.

Be free post here or github any issue or pull request about traces flags, thanks again.

Is it your blog https://orderbyselectnull.com/ ?

jobbish SSC Journeyman Points: 81 More actions · Answer 13

kast218 - Tuesday, December 5, 2017 1:31 AM
jobbish - Monday, December 4, 2017 10:21 PM
Trace flag 692 is documented here: https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-traceon-trace-flags-transact-sql
Trace flag 9448 disables the referential integrity operator and is mentioned here: https://orderbyselectnull.com/2017/12/05/the-referential-integrity-operator/
jobbish thank you very much for this info, updated via https://github.com/ktaranov/sqlserver-kit/commit/d2a1b366123ae249b49a1cbbc58ab480a5492687
Also update article here, waiting for re-publication.
Be free post here or github any issue or pull request about traces flags, thanks again.
Is it your blog https://orderbyselectnull.com/ ?

Yes, that is my blog.

Thanks for putting together this list and for all of the work you do to maintain it!

Konstantin Taranov SSCertifiable Points: 6498 More actions · Answer 14

jobbish - Tuesday, December 5, 2017 6:47 AM
kast218 - Tuesday, December 5, 2017 1:31 AM
jobbish - Monday, December 4, 2017 10:21 PM
Trace flag 692 is documented here: https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-traceon-trace-flags-transact-sql
Trace flag 9448 disables the referential integrity operator and is mentioned here: https://orderbyselectnull.com/2017/12/05/the-referential-integrity-operator/
jobbish thank you very much for this info, updated via https://github.com/ktaranov/sqlserver-kit/commit/d2a1b366123ae249b49a1cbbc58ab480a5492687
Also update article here, waiting for re-publication.
Be free post here or github any issue or pull request about traces flags, thanks again.
Is it your blog https://orderbyselectnull.com/ ?
Yes, that is my blog.
Thanks for putting together this list and for all of the work you do to maintain it!

Joe, great thanks for positive feedback.

I added you to our SQL Server People list via https://github.com/ktaranov/sqlserver-kit/commit/8752f4547c613f3ccac59ec40b9aa8741379f6db, your blog is awesome, keep writing, our team read all articles.

Alan Burstein SSC Guru Points: 61141 More actions · Answer 15

This article is awesome! Thanks for putting it together.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

SQL Server Trace Flags - Complete list

Cookies on SQLServerCentral