Welcome to the Ohio North SQL Server User Group


Our user group meets the first Tuesday of every month from 5PM-7:30PM at the Microsoft office in Independence.

Microsoft Corporation
6050 Oak Tree Blvd.
Suite 300
Independence, OH 44131

Our meetings follow the schedule below:
5:00PM - 6:00PM: Video presentation from last year's SQL PASS Summit
6:00PM - 6:15PM: Announcements & Introductions
6:15PM - 7:30PM: Feature Presentation

Afterwards, we usually continue networking across the street at Mavis Winkles.

 Upcoming Meeting

Next Meeting

Tuesday,

March

03

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: https://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.com

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