Log in | Register

Trace Flag Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Trace Flag Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

Trace Flag

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

Database Scoped Configurations and Trace flag 4199

Those who are working on query performance whether you are a DBA or Developer I am sure you guys must have used trace flag 4199.  TF 4199 enables all query optimizer related fixes.Microsoft used to have separate TF for each hotfix applied to query optimizer prior to SQL Server 2005 Service Pack 3 (SP3) Cumulative […]

By |April 16th, 2017|Categories: Database Administration, Database Development, Performance, SQL Server, Transact-SQL|Tags: , , , |Comments Off on Database Scoped Configurations and Trace flag 4199

Trace Flag 634 – Disable Background Columnstore Compression

Hi Friends,

In Columnstore Technology, we knows that Column data stores in segments and segments groups together to form the rowgroup. One of the main reason of using Columnstore technology is compression of rowgroups. By default, SQL Server perform compression of closed delta stores. This tasks is done by tuple mover. Which invokes after a […]

By |December 26th, 2016|Categories: Compression, Database Administration, Indexes & Statistics, Performance|Tags: , |Comments Off on Trace Flag 634 – Disable Background Columnstore Compression

SQL SERVER – Trace Flags

To know about a topic we usually ask questions. Here I used the same method to explain about trace flags of SQL Server.

Below are some basic questions and its answers on this.

What is the use of Trace Flag?

Trace Flags are used to enable or disable certain functionality of SQL server temporarily. It is used to […]

By |September 29th, 2016|Categories: SQL Server, Transact-SQL|Tags: , , |Comments Off on SQL SERVER – Trace Flags

SQL Server Trace Flag 8721

Hi Friends,

This is my 50th blog on SQL Server Trace Flag 8721 and last in the series of One Trace Flag a Day. I hope you enjoyed this series. You can go to all blogs under that series by clicking here.

There are lots of things which can be discussed about statistics due to its […]

By |November 11th, 2014|Categories: Indexes & Statistics, One Trace Flag a Day|Tags: , |Comments Off on SQL Server Trace Flag 8721

SQL Server Trace Flag 9204

Hi Friends,

This is my 49th blog on SQL Server Trace Flag 9204 in the series of One Trace Flag a Day. You can go to all blogs under that series by clicking here.

In my previous blog, we have seen the use of Trace Flag 9292. This loads only the header for statistics which are […]

By |November 10th, 2014|Categories: Indexes & Statistics, One Trace Flag a Day|Tags: , , |Comments Off on SQL Server Trace Flag 9204

SQL Server Trace Flags Basics

Hi Friends,

I am going to start a series on SQL Server Trace Flags. So in my first blog I want to put some light on the introduction and how to use trace flags.

Introduction: Trace flags are like a checkpoint. Enabling a trace flag is like we enabled or disabled a part of code that […]

Newsletter_Footer