statistics

/Tag:statistics

Free SQL Video: SQL Server Cardinality Estimation – Quick Notes, Part 1

Hi Friends, In this video, I am demonstrating one of the ways How SQL Server performs Cardinality Estimation - it’s always good to know more about SQL Server internals and architecture. Hope you enjoy the video. Do share it. You can also visit our Your Tube channel to watch more videos. Want to read a [...]

By |October 12th, 2014|SQL Server Videos|1 Comment

SQL Server Cardinality – Quick Notes, Part 3

Hi Friends, Read Part 1 & Part 2. SQL Server Cardinality Estimation is a complicated topic until you understand the internals of SQL Server Statistics. Here are some quick notes that will answer some common questions that you generally have: How does SQL Server Query Optimizer perform cardinality estimation in case of multiple columns? Let’s [...]

By |September 26th, 2014|SQL Server|0 Comments

Cardinality Estimation in SQL Server – Quick Notes, Part 2

Hi Friends, A few days back I penned down a few quick notes about Cardinality Estimation in SQL Server. You can read Part 1 here. SQL Server Cardinality Estimation is a complicated topic until you understand the internals of SQL Server Statistics. Here are some quick notes that will answer some common questions that you [...]

By |September 25th, 2014|SQL Server|0 Comments

SQL Server Cardinality Estimation – Quick Notes, Part 1

Hi Friends, SQL Server Cardinality Estimation is a complicated topic until you understand the internals of SQL Server Statistics. Here are some quick notes that will answer some common questions that you generally have: How does SQL Server Query Optimizer estimate a default cardinality? Let’s see and example (turn ON Actual Execution Plan or press [...]

By |September 23rd, 2014|SQL Server|0 Comments

SQL Server Statistics Histogram- How to Decode? (Statistics Internals)

Hi Friends, Here is a short explanation of the SQL Server statistics histogram. I am using AdventureWorks2008R2 database. There is a table Sales.SalesOrderHeader with a column TotalDue. Let us have a look at that column. USE AdventureWorks2008R2 GO -- first observe the rows select TotalDue from Sales.SalesOrderHeader GO select DISTINCT TotalDue from Sales.SalesOrderHeader GO You [...]

By |May 5th, 2014|SQL Server|2 Comments