Cardinality Estimates in Microsoft SQL Server

2016

TL; DR

Attend this session and understand how, why, and when SQL Server uses statistics and how the new CE will help improve performance.

Session Details

The way SQL Server estimates cardinality for a query has been updated in SQL 2014. In this session we will discuss why cardinality matters, the differences between the SQL 2014 cardinality and previous versions, and how to evaluate if your queries will benefit after upgrading from previous versions of SQL Server.

3 things you'll get out of this session

Thomas LaRock's previous sessions

From Here to Azure

Attend this interactive session and learn how to create, deploy, and migrate data from your on-premises instance of SQL Server to Microsoft Azure Virtual Machines and Microsoft Azure SQL Database.

Database Design: Size DOES Matter

Great database performance starts with great database design.

Cardinality Estimates in Microsoft SQL Server 2014

Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance.

Monitoring Databases in a Virtual Environment

This session will help DBAs to understand what changes they need to make in their performance and monitoring practices for virtualized database servers.

Database Design: Size Does Matter!

Great database performance starts with great database design. During the design process it is important to select your SQL Server datatypes wisely. Failure to do so will result in wasted disk space, additional I/O overhead, and decreased performance.