San Francisco, California
London, United Kingdom
December SQL Server user group meeting.
18:15 - Doors Open
18:30 - Introductions
18:45 - Dave Ballantyne
Estimation and Statistics : The Basis of query optimization
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.
19:45 - Pizza, drinks & chat
20:15 - Prize Draws
20:30 - End
When & Where
Southampton SQL Server User Group
Southampton SQL Server user group has been running since 2010, in that time we have had many speakers both local and international present high quality sessions on a range of SQL Server and data platform topics. We aim to deliver high quality training and insight for free to the SQL Server community.
The user group has been run by John Q Martin (Twitter | LinkedIn) & Steph Middleton (Twitter | LinkedIn) for the last three years, in which time we have seen the group grow significatly with members joining and moving on.
We are spponsored by SpectrumIT who are a local recruitment company, setup by recrutiment agents who have helped us by providing the location, Pizza and an Amazon voucher to raffle off each meeting.