Eugene SQL Server User Group - Feb 13th - Lunch

Speaker: Vern Rabe

Topic: SQL Server Statistics

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 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?), correlated predicates, 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. 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.

LinkedIn : http://www.linkedin.com/pub/vern-rabe/a/ba3/980

Twitter : @VernRabe

********************************************************************
************************* IMPORTANT *****************************
********************************************************************
Please attend, as we have some Chapter money, so I would like to throw a member appreciation party at the next meeting (March 13th), and would like input from YOU. Kevin Kline is already slated to be the speaker that night, so let's push our market reach and have a great time!

**********************************************************************************************
Food: Food is being provided by Tek Systems.

Reminder to all: Please register as a member of PASS ( http://sqlpass.org ) it's FREE, and associate yourself with our chapter. It's how they keep track of our activity, and our size, which will help us when the SQLSaturday thing comes around. (Spring 2019!)

Home Page:
http://eugene.sqlpass.org/

Contact us via email at: eugene.oregon@sqlpass.org

We have a discussion board at
http://groups.google.com/group/eugenesql?hl=en .

Ask your questions and hear from the community. Also, like us on Facebook here:
https://www.facebook.com/groups/123723384306270/requests/?notif_t=group_r2j

Follow us on Twitter: @EugeneSQL

or our LinkedIn Group:
https://www.linkedin.com/groups/3681739