SQL2014 : The all new cardinality estimator

A vital component inside the query optimizer is the cardinality
estimator,  these are the algorithms that calculate the estimated number
of rows will be outputted from each operator.  In SQL Server 2014, there
have been many changes aimed at giving a more accurate number of rows, and
therefore better plans.

This session will be a look at these changes, comparing and
contrasting with SQL2012/2008 to see how they help.
Presented by Dave Ballantyne at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    dave_ballantyne.jpg
    Dave is a freelance SQLServer database developer / designer and has been working in the IT field for over 20 years,  the past 15 of which has been specialising within SQLServer environment. 
    http://www.clearskysql.co.uk http://dataidol.com/davebally/feed/
  • Video
    The video is not available to view online.