Estimation, Statistics and “Oh My!” with Dave Ballantyne
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.
Bio
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.
Dave is a regular speaker at UK events such as SQL Bits and user groups. He also is founder of the SQLLunch User Group.
19:30 - 19:50 -