Cardinality Estimation

/Tag:Cardinality Estimation

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