Platinum Sponsor

Estimation, Statistics and “Oh My!”



At the heart of SQL Server is the cost based optimizer.  Stop and think about that a minute, it
attempts to give the “best plan” based on the cost of the work undertaken.  How does it know the cost of the work before
its done the work ? This isn’t a conundrum, it doesn’t.  It estimates! 
How does it estimate ? That is statistics.

This will be a deep dive into how the optimizer makes its
decisions to give you a plan, the things that can go wrong and how you can have
influence over these choices.

Presented by Dave Ballantyne at SQLBits XI
Tags (no tags)
  • Downloads
    Slide deck available Slide Deck 2.3 MB
    Video available MP4 Video Low 101 MB
    Samples available Demo Code 4 KB
    Video available MP4 Video Med 191 MB
    Video available MP4 Video HD 526 MB
  • 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.
  • Session Files Explorer
    The network name cannot be found.