June 8, 2016: Query Optimization Statistics

 

1515 SW 5th Ave. Suite 900, Portland, OR

Download the Presentation Material here.
Vern Rabe
Statistics: The Driving Force Behind Good Query Performance

When the SQL Server optimizer evaluates a query to determine how best to execute it, the statistics are quite possibly the most important tool at its disposal. But SQL Server statistics objects aren’t perfect because they only contain summary information. In this session, we’ll start with an overview of what the statistics objects are, how the optimizer uses them, and some general guidelines for their maintenance. Then we’ll look at some of the issues – and solutions – that can arise due to their imperfection: ascending keys, correlated predicates, skewed distribution, or downright bad summary information.

Vern Rabe Vern (LinkedIn | Twitter) is an independent SQL Server consultant and contract trainer in Portland, OR. He has attained MCSE, MCITP (both Administration and Development), and MCT certifications, among others. Vern has been working with databases since 1992, and has worked with SQL Server since version 4.21a. He provides broad technical SQL Server skills gained from the mixture of academic and practical experiences acquired from his classroom instructing and varied consulting contracts


Register NowDon’t miss this meeting!

Refreshments graciously provided

Featured Sponsor: Idera
Visit our website for more details.


We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.


Posted in Announcements | 3 Comments