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

• Cardinality Estimation (Books Online)

• Cardinality Estimator - What's New in SQL Server 2014

• The SQL 2014 Cardinality Estimator Eats Bad T-SQL for Breakfast

• SQL Server 2014's new Cardinality Estimator (part1)

• Joe Sack's series on CE

• Identifying SQL Server 2014 New Cardinality Estimator issues and Service Pack 1 improvement

Continue learning more about SQL Server

View the index of features for the various versions.

• The complete list of new features for SQL Server 2016.
• Features in SQL Server 2014
• Features in SQL Server 2012