New Cardinality Estimator Part 3 – Single Table And One Predicate

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. SELECT * FROM T WHERE col = some_value). Since this is a very simple case I don’t expect significant changes. […]

New Cardinality Estimator Part 2 – Modulo Operator

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 of “equal to” when you compare the result of modulo 2 operation with the constant 1. The result of a Modulo 2 operation is reminder of the […]

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 performance and usage of your OLTP system. However, for both of them you can decide when, how, and in which degree you will implement them. In the series […]