Question : I want to minimize the output of certain warnings and messages in the SQL Server 2012 logs, such […]
Tag: trace-flags
Azure SQL Database vs. error 8152 enhancement
Question : How can I take advantage of the enhancement for error 8152 (https://blogs.msdn.microsoft.com/sql_server_team/string-or-binary-data-would-be-truncated-replacing-the-infamous-error-8152/) in Azure SQL Database? Even when […]
Difference in behaviour between `DBCC TRACEON` and `QUERYTRACEON`
Question : I am using SQL server 2014, but my database version is SQL server 2012. So I am trying […]
Methods for finding new Trace Flags in SQL Server
Question : There are a lot of Trace Flags out there. Some are well-documented, some are not, and others found […]
SQL Server Lock Escalation clarity required
Question : I want to know whether Enabling the Trace Flag 1211 globally prevents the Lock Escalation even in the […]
Why does DBCC TRACEON (1204, 1222) not work?
Question : I have executed DBCC TRACEON (1204, 1222) on several servers. Some of them simply do not turn the […]
Enabling trace flag 8048
Question : My database is running on SQL Server 2012 with 32 core processors. As per sp_blitz (by Brent Ozar) […]
SQL Server Processor affinity with trace flag 8002 ON
Question : I have been going through an article that explains the unwanted side effects of Setting a Processor Affinity […]
Trace flag 2861 and what a ‘zero-cost’ plan actually means
Question : I’m trying to get my head around trace flag 2861 and what it actually does with trivial queries? […]
Is Trace Flag 6534 Relevant Past SQL Server 2016?
Question : Based on this link, I see that trace flag 6534 is relevant for SQL Server 2012 through 2016, […]
- 1
- 2