March 2, 2017 at 12:46 am
admin 31599 - Wednesday, March 1, 2017 10:14 PMLink 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.
March 31, 2017 at 1:59 am
kast218 - Thursday, March 2, 2017 12:46 AMadmin 31599 - Wednesday, March 1, 2017 10:14 PMLink 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 AMEd Wagner - Sunday, February 26, 2017 4:44 PMThat'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/
March 31, 2017 at 2:38 am
steinar.andersen@sqlservice.se - Friday, March 31, 2017 1:59 AMkast218 - Thursday, March 2, 2017 12:46 AMadmin 31599 - Wednesday, March 1, 2017 10:14 PMLink 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 AMEd Wagner - Sunday, February 26, 2017 4:44 PMThat'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.
April 3, 2017 at 6:23 am
kast218 - Friday, March 31, 2017 2:38 AMsteinar.andersen@sqlservice.se - Friday, March 31, 2017 1:59 AMkast218 - Thursday, March 2, 2017 12:46 AMadmin 31599 - Wednesday, March 1, 2017 10:14 PMLink 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 AMEd Wagner - Sunday, February 26, 2017 4:44 PMThat'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!
April 3, 2017 at 6:30 am
steinar.andersen@sqlservice.se - Monday, April 3, 2017 6:23 AMkast218 - Friday, March 31, 2017 2:38 AMsteinar.andersen@sqlservice.se - Friday, March 31, 2017 1:59 AMkast218 - Thursday, March 2, 2017 12:46 AMadmin 31599 - Wednesday, March 1, 2017 10:14 PMLink 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 AMEd Wagner - Sunday, February 26, 2017 4:44 PMThat'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.
April 3, 2017 at 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? 😉
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
April 5, 2017 at 8:10 am
SQLRNNR - Monday, April 3, 2017 12:23 PMWhile 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.
May 31, 2017 at 4:12 am
Add new 7 trace flags - now 518. Update some info and fix broken links, add new links.
September 15, 2017 at 5:30 am
??????, ????? 9806, 9807 ? 9808 ?????????? ????? ?????????? ? ????????? ??????? ????? -? (??????? ????????? ?????? ?????????? ???????? ??????????? ? ???????? ??????????????????).
September 15, 2017 at 6:38 am
gladchenko-495957 - Friday, September 15, 2017 5:30 AMПохоже, флаги 9806, 9807 и 9808 поÑвлÑÑŽÑ‚ÑÑ Ð¿Ð¾Ñле добавление в параметры запуÑка флага -Ñ… (который выключает многие вÑтроенные ÑредÑтва мониторинга и Ñчётчики производительноÑти).
ÐлекÑандр, ÑпаÑибо за Ñообщение. Ðе могли бы вы дать ÑÑылку или подробнее опиÑать данные флаги?
December 4, 2017 at 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/
December 5, 2017 at 1:31 am
jobbish - Monday, December 4, 2017 10:21 PMTrace 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/ ?
December 5, 2017 at 6:47 am
kast218 - Tuesday, December 5, 2017 1:31 AMjobbish - Monday, December 4, 2017 10:21 PMTrace 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!
December 6, 2017 at 7:11 am
jobbish - Tuesday, December 5, 2017 6:47 AMkast218 - Tuesday, December 5, 2017 1:31 AMjobbish - Monday, December 4, 2017 10:21 PMTrace 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.
February 14, 2019 at 2:32 pm
This article is awesome! Thanks for putting it together.
-- Itzik Ben-Gan 2001
Viewing 15 posts - 16 through 30 (of 38 total)
You must be logged in to reply to this topic. Login to reply