Performance Management 1 Day Certification Training in Detroit, MI
Performance Management 1 Day Certification Training in Detroit, MI
Fri, Mar 24, 9:00 AM
Detroit, MI • Detroit, MI
$649 - $849
Actions Panel
SQL PASS in Detroit - Erin Stellato - Updating Statistics Affects Query Performance More than You Think
By SQL PASS in Detroit (SPID)
When and where
Date and time
Thursday, April 16, 2015 · 6 - 8pm EDT
Location
Microsoft Office 1000 Town Center Suite 1930 Southfield, MI 48075
Description
To: All Members of the SQL PASS in Detroit (SPID) User Group.
You are cordially invited to the April edition of SQL PASS in Detroit (SPID)scheduled for April 16th. Join us as Erin Stellato explains the different ways that updating statistics can impact your query performance.
This month's meeting is sponsored by SQL Pass in Detroit (SPID), SIOS, and Microsoft. Please visit their websites.
Register at EventBrite http://erin-stellato-stats-perf.eventbrite.com so we know how much food to order.
Also check out our web site at http://detroit.sqlpass.org/
Date: Time:
Thursday, April 16, 2014 6:00 PM to 8:00 PM
Location: Directions:
Microsoft Southfield Office Directions found by clicking here.
1000 Towncenter
Suite 1930
Southfield, MI 48075
Registration: Register at EventBrite – http://erin-stellato-stats-perf.eventbrite.com
Topic – Updating Statistics Affects Query Performance More Than You Think
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.
Speakers – Erin Stellato
Erin Stellato is a Principal Consultant with SQLskills and lives in Cleveland, OH. She has over 13 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.