Cardinality Estimator on SQL Server 2014/2016

Target Audience:

SQL Server database administrators and developers.


Cardinality Estimator had a major upgrade in SQL Server 2014 version and 2016. After a few introductory words, I will speak about model assumptions of Cardinality Estimator, calculation direction, model selection of Cardinality Estimator and improvements in SQL Server versions 2014 and 2016. I will also have a few demos where I will demonstrate how to optimally use the new features.

Why I Want to Present This Session:

Additional Resources:

The following two tabs change content below.

Dean Savović

Head of Data Management Department at Comminus d.o.o.
Dean is Senior DBA practicing SQL Server since version 7.0 and main areas of interest are performance tuning and troubleshooting SQL Server database. He speaks at Microsoft Windays Croatia, Advanced Technology Days Croatia, SSWUG, KulenDayz Croatia, SQL Saturday events, etc... Primary focus is on OLTP databases with occasional adventures with Business Intelligence. He finished Faculty of Electrical Engineering and Computing and MBA on Faculty of Economics in Zagreb. His premise was that it is very useful to combine technical knowledge with management process knowledge that help us in our everyday work. He works in Comminus which is specialized in data management field on Microsoft SQL Server. When he is free he reads, and thinks about SQL Server.

Latest posts by Dean Savović (see all)

Previous Post
€20M+ fines and prison: General Data Protection Regulation (GDPR) is coming. What does this mean for DLM?
Next Post
I Needed to Install 80 SQL Servers…Fast. Here’s How I Did It!

3 Comments. Leave new

Dean – thanks for the abstract.

Think about your perfect audience member and ask yourself:
* Do they know what the term “Cardinality Estimator” means?
* If no, how do you need to introduce it in the abstract? People may not know why they need to attend.
* If yes, what parts of this abstract do they already know? What new things are you going to teach them?

The CE is kinda like parameter sniffing in that there’s 3 kinds of audience members:
* People who don’t know that it exists
* People who know it exists, but don’t know any technical details
* People who know tons of technical details about it

The key to a great abstract on a topic like that is to understand which audience member you’re targeting, and then write the abstract just for them.


Hi Brent,
I don’t know how to change the abstract. 🙂


Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.