Log in | Register

Indexes & Statistics Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Indexes & Statistics Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

Indexes & Statistics

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

The correct cardinality estimation for table variable using trace flag 2453

Hi Friends,

My today’s blog post is focused on the correct cardinality estimation for table variable using trace flag 2453. In one of my previous blog post, we have seen the use of OPTION (RECOMPILE) query hint for correct cardinality estimation in case of table variable. Now the question is, Is there any way to […]

SQL Server 2016 CTP – Alter Column Online Operation

Hi Friends,

Various new features and improvements are coming with SQL Server 2016. Various performance improvements are also added to the CTP versions. Today, I’ll show you one of them i.e. Alter Table … Alter Column online operation.

Blocking is one of the major problems when you work on performance tuning for SQL Server. We knows […]

The correct cardinality estimation using table variable

Hi Friends,

In my previous blog post, we have seen that SQL Sever estimates number of rows in a table variable was 1. Now the question is, Is there any way to make the correct estimation for the number of rows while using table variable?

My today’s blog post is focused on the correct cardinality estimation […]

Nested Loop Join – Temp Table versus Table variable

Hi Friends,

In my previous blog post, I have shown you the working of nested loop join in SQL Server. Today, I am going to show you the Nested Loop Join – Temp Table versus Table variable.

Before executing a query, SQL Server generates an estimated execution plan on the basis of various server settings and […]

Forward and Backward Scan

Hi Friends,

First of all wish you all a very Happy New Year 2016. I hope this new year will bring lots of joy and happiness in your life. Today, I’ll show you the Forward and Backward Scan.

We all knew that whenever we  create an index (Clustered or Non-Clustered) on a table in SQL Server […]

Maintenance Plans – A Tale of Seven Wonders – Wonder 1

Hello geeks,

Welcome to the new series of seven wonders of SQL Server. These are not the wonders which make you say Awww. These are the ones which make you really wonder why. I will be covering the seven of such jaw dropping situations where you wonder what is happening and few bizarre reasons why […]

Non Clustered Index Key Length in SQL Server 2016 CTP 3.0

Hi Friends,

We all are aware about clustered and non clustered indexes in SQL Server. We are also aware about limitation of Non clustered index key length i.e. 900 bytes. That means you can’t have key length data size more than 900 bytes. I tried to explain the same thing in one of my blog […]

Hidden Gems of SQL Server 2014 – Managed Lock Priority

Problem Statement:
Theoretically online index rebuild does not block. Practically boom… They do. Online index rebuild operations does not take down your indexes. But there is a point in the index rebuild where they build the new index structure and switch from your old index structure to new one. This is a simple metadata pointer […]

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 […]

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 […]

Newsletter_Footer