Upcoming Meetings  

Wednesday, September 7, 2016 - Henry Treftz - Lessons from the Software Company 

Wednesday, October 5, 2016 - Lori Edwards - SQL Server Statistics 

Wednesday, November 2, 2016 - Lightning Talks 


We meet at Concordia University, 4351 W College Ave, Appleton WI 54914. This is just west of Hwy 41. 



Next Meeting: Wed, Oct 05 2016

FoxPASS October 2016 Meeting

Language: English
Event Type: In-Person & Online
Online Meeting URL: None
RSVPURL: None

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

When

iCal
Event Time : Wed, Oct 05 2016 17:30 - 19:30 Central Daylight Time
Your Local Time: Wed, Oct 05 2016 22:30 - 00:30

Where

4351 W College Ave
Appleton, Wisconsin

Direction: None

Featured Presentation

SQL Server Statistics

Speaker: Lori Edwards, Sales Engineer SQL Sentry

Summary: 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 is a Microsoft Certified SQL Server Database Administrator. She currently holds the position of Sales Engineer for SQLSentry. Prior to working with SQLSentry, she spent 10 years working as a production DBA. Between volunteering with the Program Committee coordinating with other volunteers to put the PASS Summit together, working as a remote employee over the last year and working with SQLSentry clients, she has had plenty of opportunity to hone her communication skills.

Attachments