SIOS SANless clusters

SIOS SANless clusters High-availability Machine Learning monitoring

  • Home
  • Products
    • SIOS DataKeeper for Windows
    • SIOS Protection Suite for Linux
  • News and Events
  • Clustering Simplified
  • Success Stories
  • Contact Us
  • English
  • 中文 (中国)
  • 中文 (台灣)
  • 한국어
  • Bahasa Indonesia
  • ไทย

March 3, 2015: SIOS Sponsors Ohio North SQL Server User Group

Date: February 3, 2015
Tags: #SANLess Clusters for Windows Environments, SQL Server User Group

SIOS is proud to sponsor the Ohio North SQL Server User Group’s March meeting. If you’re in the area, I highly recommend checking out this month’s session “Updating Statistics Affects Query Performance More Than You Think” featuring Erin Stellato, Principal Consultant SQLskills.com.

Register Now

Location: Microsoft Corporation, 6050 Oak Tree Blvd. Suite 300, Independence, OH 44131
Date: March 3, 2014
Time: 6:00 PM – 8:00 PM

Session Abstract

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 Stellato

Erin Stellato is a Principal Consultant with SQLskills and lives in Cleveland, OH. She has over 12 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.

 

Copyright © 2023 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in