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.


This entry was posted in Announcements. Bookmark the permalink.

3 Responses to June 8, 2016: Query Optimization Statistics

  1. Wayne A. Borum says:

    Vern,

    Thank you for the excellent presentation on statistics. It was very informative and I certainly learned things that will be helpful in chasing some issues we are currently facing with some bothersome queries.

    Would it be possible for you to post the stored procedure that you wrote and demonstrated that can be used to locate out-of-range index entries? I have a suspicion that some of my problems may be related to stale stats and your sp would help me determine whether that is the case or not.

    Thanks again for the great presentation.

    Wayne

    • Oregon SQL Admins says:

      Thank you, and I’m glad you see value in it. The slide deck, demo script, and stored procedure have been posted on our web. You can download it from there.
      Vern Rabe

      • Wayne A. Borum says:

        Vern,

        I’m sorry to be a pest, but when I click on “Download the Presentation Material here” I still get 2 files. One is the SQL demo code that you used and the other is the PowerPoint presentation and both are dated in mid January 2016. I’m still not seeing the stored procedure. Do you have any suggestions about what I’m doing wrong?

        Thanks,
        Wayne

Comments are closed.