In this article I will explore changes in new CE related to column correlation. As mentioned in my first article about new CE, this change is announced in the paper Testing Cardinality...
New Cardinality Estimator Part 3 – Single Table And...
In this article I will try to find out is there any change in cardinality estimation in a very simple case of querying a single table with a single predicate with the equal operator (i.e...
New Cardinality Estimator Part 2 – Modulo...
Three months ago Transact SQL Guru Itzik Ben-Gan (blog | twitter) posted a small T-SQL puzzle with a question why should you use “greater than or equal to” operator instead...
New Cardinality Estimator Part 1
SQL Server 2014’s main favorites are definitely In-Memory OLTP engine and cluster column stored indexes and if you find proper use cases for them you can significantly improve...