Welcome to the Central Illinois SQL Server User Group!

 

We are an official SQL PASS chapter, serving all of Central Illinois, which includes Quincy, Peoria, Bloomington/ Normal, Springfield, Decatur, Champaign, Danville and all the great communities that make up Central Illinois.

Next Meeting

Tuesday,

January

26

Central Illinois SQL Server User Group January 2016

Erin Stellato will be presenting a session on how statistics affects query performance on January 26th, 2016 at 6:15PM.  We will be starting the presentation promptly at 6:30 PM.  Ms. Stellato will be remote and we will have a WebEx meeting that you can use to connect to the meeting or you can come to Afni Headquarters in Bloomington, IL to experience the session with other professionals.  For the first 5 people that sign up to attend the meeting in person and attend the meeting in person will receive a gift from Pluralsight .

 

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.


Meeting Agenda:

6:15PM Social & Networking

6:30 PM Presentation

8:00 PM? Closing notes for the year

 

Meeting number:      622 000 732

Meeting password:  tuesday1       


 

Join by phone        

1-650-479-3208 Call-in toll number (US/Canada)        

Access code: 622 000 732


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.

Training Opportunities:

 

SQL Saturday's

PASS SQLSaturday’s are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Whether you're attending a SQLSaturday or thinking about hosting your own, we think you'll find it's a great way to spend a Saturday – or any day.  I've only listed a few that are in driving distance; many more are listed at the "SQL Saturday" home page.


SQL Saturday Home

SQL Saturday Indianapolis - August 12, 2017

SQL Saturday Kansas City - October 7, 2017

 

PASS SUMMIT

Summit 2017 Seattle - October 31st, 2017 - November 3rd, 2017

 

 

cage-aids
cage-aids
cage-aids
cage-aids