BEGIN:VCALENDAR VERSION:2.0 PRODID:-//SQLBits/com CALSCALE:GREGORIAN METHOD:PUBLISH X-MS-OLK-FORCEINSPECTOROPEN:TRUE BEGIN:VEVENT DTSTART:20130504T150000Z DTEND:20130504T160000Z LOCATION:SQLBits Conference - Suite 4 SUMMARY:Estimation, Statistics and “Oh My!” DESCRIPTION:

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.

X-ALT-DESC;FMTTYPE=text/html:

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.

Dave Ballantyne

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 regularly contributes to online forums and is a regular speaker at UK events such as SQL Bits and user groups. He also is founder of the Kent .NET/SqlServer user group.

http://www.clearskysql.co.uk UID:SQLBITS1556SEQUENCE:0 DTSTAMP:20130518T105310Z END:VEVENT END:VCALENDAR