header

 
NEXT MEETING:
January 23rd, 2020 6:30 PM

 
LOCATION:(new location!)
Greenbrier Meeting Room
3 Centerpointe Dr
Lake Oswego, OR 97035


  PRESENTATION:
Query Optimization Statistics - The Driving Force Behind Performance with Vern Rabe

DESCRIPTION
When the SQL Server optimizer evaluates a query to determine how best to execute it, the statistics are quite possibly the most important information at its disposal. But SQL Server statistics objects aren’t perfect because they only contain estimated 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, how to find them, and how to solve them, that can arise due to their imperfection: ascending keys (the most prevalent statistics based performance killer?), skewed distribution, or downright bad summary information. There’ll be many examples, and even a stored procedure to help you find ascending keys. By applying the techniques we’ll discuss, you WILL see improved query performance.


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


 

 


CORPORATE SPONSORS

Vanderhouwen PASS Chapter Logo Vanderhouwen


copyright ©2019, Portland SQL Server User Group and pdxssug.com all rights reserved.
Redistribution of any portion of this site is forbidden without prior written permission.