Ohio North SQL Server User Group

Choose a meeting below to view its details


Meeting Archive

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: 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 Data Platform MVP and lives outside Cleveland, OH. She has almost 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Query Store, Extended Events, and helping accidental/involuntary DBAs understand how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences including the PASS Summit, SQLIntersection, and SQLBits. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids