What's Happening?

Next Meeting: Fri, Jun 12 2015

June Meeting

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

June Meeting

When

iCal
UTC : Fri, Jun 12 2015 17:30 - 19:00
Event Time : Fri, Jun 12 2015 11:30 - 13:00 Mountain Daylight Time
Your Local Time: Fri, Jun 12 2015 17:30 - 19:00

Where

5100 Masthead St NE
Albuquerque, New Mexico

Direction: None

Featured Presentation

Updating Statistics Affects Query Performance More Than You Think

Speaker: Erin Stellato, Principal Consultant SQLskills

Summary: Stop me if you've heard this one, "This query is slow, let's update statistics." But what does updating statistics *really* do to your query performance? And is it the right solution? While updating statistics may provide a short-term solution, it can bury the true root cause. If you’re not familiar with what happens to query plans when you update statistics, then don’t miss this session. We’ll set the stage with a review of what statistics are, how the optimizer uses them, and discuss the various ways you can update them. Then we’ll explore what happens to plans when you *do* update statistics, and you’ll see why that might not always be the right long-term solution.

About Erin: Erin Stellato is a Principal Consultant with SQLskills and lives in Cleveland, OH. She has over 15 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high availability and disaster recovery. Erin is a SQL Server MVP and an active member of the SQL Server community. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.

Attachments

Please be sure to check out our Meetup.com page, and RSVP there for our monthly meetings.

PASS membership is not a prerequisite to attend this or any other monthly meeting of the Albuquerque SQL Users Group, however, you can enjoy many benefits of being a member by signing up for a FREE PASS membership at http://www.sqlpass.org/.