Lori Edwards is a Microsoft Certified SQL Server Database Administrator. She currently holds the position of Sales Engineer for SQLSentry. Prior to working with SQLSentry, she spent 11 years working as a production DBA. She has volunteered with PASS for several years including last year's Nomination Committee and the Program Committee coordinating with other volunteers to put the PASS Summit together, for which she won the 2011 PASSion award.
This session will explain how the Query Optimizer uses column statistics to determine which operators to use and the operator costs. We'll also look at the changes to the Cardinality Estimator in SQL Server 2014.