SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Learning about the Cardinality Estimator

By Site Owners,

The Cardinality Estimator is a part of the query processos that helps to generate an appropriate query plan. This is important for producing the most efficient performance for your queries.

We have included a number of links that can help you learn more about the AlwaysOn suite of technologies, broken out by SQL Server version where applicable. 

If you find broken links or have additional suggestions for information, please leave a comment in the discussion for this article.

SQL Server 2016

Continue learning more about SQL Server

View the index of features for the various versions.

 
Total article views: 171 | Views in the last 30 days: 1
 
Related Articles
BLOG

SQL Server 2014 Cardinality Estimator

SQL Server 2014 Cardinality Estimator The SQL Server 2014 cardinality estimator has been improved...

ARTICLE

Cardinality Estimator – What’s new in SQL Server 2014

SQL Server 2014 has introduced a rebuilt Cardinality Estimator (CE) with new algorithms. Which are t...

BLOG

The Cardinality Estimator in SQL Server 2014 – Going Forward and Backward

I saw a talk from Joe Sack (b | t) on the cardinality estimator (CE) in SQL Server 2014 and found......

BLOG

Fixing Cardinality Estimation Errors with Filtered Statistics

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings ...

BLOG

Cardinality Estimation – Table Variable Vs Temporary Table in SQL Serve

SQL Server creates and maintains statistics for temporary tables, which lead to better cardinality e...

 
Contribute