Fox Valley Microsoft Data Platform

Next Meeting

Wednesday,

October

05

FoxPASS October 2016 Meeting

  • In-Person & Online @ 100 W Lawrence St, Suite 100 Appleton Center Appleton, Wisconsin, United States (map)
  • 17:30 - 19:30 Central Daylight Time
  • Language: English
  • RSVP URL: None

This month's meeting features Lori Edwards from SQL Sentry, helping us get better performance in SQL Server through statistics. 

Featured Presentation:

SQL Server Statistics

Lori Edwards, Solutions Engineer SentryOne

For far too long, I thought that statistics only contained information on table row counts. While they do contain that information, there is more to it than that. In this beginner session, we’ll go over statistics – how they are created, the different types of statistics that exist, how they’re maintained and how the Query Optimizer uses them. We will also touch on system tables and DMVs that will provide additional information on your statistics. We'll also go over the cardinality estimator changes in 2014/2016. At the end of this session, you should have a better idea of how the query optimizer within SQL Server makes decisions on how to gather data.

About Lori:
Lori Edwards currently holds the position of Solutions Engineer for SentryOne. Prior to working with SQLSentry, she spent 11 years working as a production DBA. She also has volunteered for PASS since 2009 on the Program Committee, ERC, Nomination Committee and speaking at SQL Saturdays.

Bronze Sponsors

 

Hosts

 

Other Sponsors

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif 

 

Brent Ozar Unlimited

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids