Add trace flags 8670 and 1252

ktaranov / sqlserver-kit

Useful links, scripts, tools and best practice for Microsoft SQL Server Database

http://sqlserver-kit.org

MIT License

2.14k stars 669 forks source link

Add trace flags 8670 and 1252 #196

Closed jobbish-sql closed 2 years ago

jobbish-sql commented 2 years ago

Trace flag 8670 is mentioned here: https://www.sql.kiwi/2012/05/query-optimizer-deep-dive-part-4.html

Trace flag 1252 is totally unrelated and something that I found while fooling around. It prints some kind of lock related information when 3604 is also enabled. Don't know anything else. Example:

SELECT * FROM master..spt_values
OPTION (QUERYTRACEON 1252, QUERYTRACEON 3604);

ktaranov commented 2 years ago

Great thanks! Added via https://github.com/ktaranov/sqlserver-kit/commit/f57bc29cdc12859642419a92e2ef9e2a0a895f3b