Susantha Bathige

Susantha Bathige

Susantha Bathige

Susantha Bathige (MSc, BCS, MCSA, MCITP) is a Microsoft Certified database professional specialize in relational database product, Microsoft SQL Server. He has more than 16 years of IT experience including more than ten years in database development and administration in non-production and production environments. He has experience of other databases systems such Cassandra and MongoDB as well. Blogs: http://www.sqlservertorque.net/ and http://www.databasetorque.com/
Susantha Bathige

Latest posts by Susantha Bathige (see all)

Understanding Skewed Data in SQL Server

May 22, 2017 by

Introduction

I recently did some research to analyze skewed data distribution in SQL Server. This article is the outcome of my analysis to share with SQL Server community.

SQL Server understands its data distribution using statistics. The SQL Server query optimizer then uses the statistics to calculate estimated row counts when executing the queries submitted by users. The accuracy of estimated row count is crucial to get optimal execution plans. The SQL Server query optimizer is a complex mathematical component and it does a decent job to create better execution plans during a very short period of time.

Read more »