Ohio North SQL Server User Group

Choose a meeting below to view its details

Meeting Archive




March Meeting

  • In-Person @ 6050 Oak Tree Blvd. Independence, Ohio, United States (map)
  • 17:00 - 19:30 (UTC-05:00) Eastern Time (US & Canada)
  • Language: English

RSVP: http://www.eventbrite.com/e/march-meeting-tickets-15784390537

Our sponsor for this meeting is SIOS! ( http://us.sios.com/ )

Please take a minute to check our their site and see what they have to offer and don't hesitate to contact them if you have any questions.

5:00 - 6:00

Pre-Session Video: Writing Faster Queries Using SQL Server 2014

Pre-Session Abstract:CPUs are running faster now than ever before, solid-state drives are replacing spinning disks, and database servers have terabytes of RAM. And yet we still suffer from poor database performance. Why? Because a poorly written query will bring even the best hardware to its knees. For truly great performing systems there is no substitute for properly written queries, good indexes, and a database design that takes advantage of all SQL Server has to offer. And for this we rely on the skills and expertise of DBAs and database developers. Join Microsoft SQL Server Certified Masters, Tim Chapman and Thomas LaRock, to learn how to spot common query performance killers and what you can do to make queries execute as fast as possible.

6:00 - 6:30

Opening & Announcements

Sponsor Intro

Officer Elections

6:30 - 7:30

Feature Presentation

Featured Presentation:

Updating Statistics Affects Query Performance More Than You Think

Erin Stellato, Principal Consultant SQLskills

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 17 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.

Back to Top