#dbcc traceon

[seniordba]

Microsoft SQL Server Trace Flag List

Microsoft SQL Server Trace Flag List

A list of known SQL Server Trace Flags that I think helps communicate this important information. Trace Flags are additional settings that in some way alters the default behavior of SQL Server. You can use these in a couple of different ways:

You can use the DBCC TRACEON and DBCC TRACEOFF commands

You can use the -T option in the startup configuration for the SQL Server Service

You can use the D…

View On WordPress

[seniordba]

Microsoft SQL Server Trace Flag List

Microsoft SQL Server Trace Flag List

A list of known SQL Server Trace Flags that I think helps communicate this important information. Trace Flags are additional settings that in some way alters the default behavior of SQL Server. You can use these in a couple of different ways:

You can use the DBCC TRACEON and DBCC TRACEOFF commands

You can use the -T option in the startup configuration for the SQL Server Service

You can use the D…

View On WordPress

[seniordba]

Setting CE TraceFlags on a query-by-query (or session) basis

Setting CE TraceFlags on a query-by-query (or session) basis

Using TraceFlags  on a query-by-query basis as described by Kimberly Tripp. This article does a great job of explaining this technique.

While the new cardinality estimator can offer benefits for some queries, it might not be perfect for ALLqueries. Having said that, there is an OPTION clause that allows you to set the CE for that query. The setting to use depends on the CE that you’re running…

View On WordPress

[seniordba]

SQL Server Trace Flag List

SQL Server Trace Flag List

A list of known SQL Server Trace Flags that I think helps communicate this important information. Trace Flags are additional settings that in some way alters the default behavior of SQL Server. You can use these in a couple of different ways:

You can use the DBCC TRACEON and DBCC TRACEOFF commands

You can use the -T option in the startup configuration for the SQL Server Service

You can use the D…

View On WordPress

[seniordba]

SQL Server Trace Flag List

SQL Server Trace Flag List

I saw an article with a list of known SQL Server Trace Flags, and thought I would help communicate the list. Trace Flags are additional settings that in some way alters the default behavior of SQL Server. You can use these in a couple of different ways:

You can use the DBCC TRACEON and DBCC TRACEOFF commands

You can use the -T option in the startup configuration fo the SQL Server Service

You can…

View On WordPress

[seniordba]

SQL Server Trace Flag List - 2330 Update

SQL Server Trace Flag List – 2330 Update

[Update] – Added the Trace Flag 2330

I saw an article with a list of known SQL Server Trace Flags, and thought I would help communicate the list. Trace Flags are additional settings that in some way alters the default behavior of SQL Server. You can use these in a couple of different ways:

You can use the DBCC TRACEON and DBCC TRACEOFF commands

You can use the -T option in the startup…

View On WordPress

[seniordba]

SQL Server Trace Flag List

SQL Server Trace Flag List

[Update] – Added the Trace Flag 6498 that was added with SQL Server 2014 CU1/6

A list of known SQL Server Trace Flags that I think helps communicate this important information. Trace Flags are additional settings that in some way alters the default behavior of SQL Server. You can use these in a couple of different ways:

You can use the DBCC TRACEON and DBCC TRACEOFF commands

You can use the -T…

View On WordPress

[seniordba]

SQL Server Trace Flag List - Updated

SQL Server Trace Flag List – Updated

[Update] – Added the Trace Flag 2453 that was added with SQL Server 2012 SP2

I recently saw an article with a list of known SQL Server Trace Flags, and thought I would help communicate the list. Trace Flags are additional settings that in some way alters the default behavior of SQL Server. You can use these in a couple of different ways:

You can use the DBCC TRACEON and DBCC TRACEOFF commands

You…

View On WordPress