Chicago Suburban SQL Server User Group

MEMBERSHIP

If you have not done so already, please register on PASS.  Then update your PASS Profile & Join our Chapter there. All future mailings will be sent out via your SQLPass account:

http://www.sqlpass.org/PASSChapters/LocalChapters.aspx

Quick Search on "Chicago Suburban SQL Server User Group" and make sure you are registered as a member.  Doing so will ensure that you will receive future e-mails from us.

Next Meeting

Tuesday,

July

17

July Meeting

  • In-Person @ 3025 Highland Pkwy Downers Grove, Illinois, United States (map)
  • 18:00 - 21:00 Central Daylight Time
  • Language: English

LOCATION:
Microsoft Downers Grove

AGENDA:
5:30PM - Doors Open
6:00PM - Meeting Start with Dinner, Networking, & Open Q&A (bring your questions!)
6:30PM - Announcements, Sponsor Presentation, & Main Presentation

TITLE:
Getting Better Query Plans by Improving SQL's Estimates

ABSTRACT:
You've been writing T-SQL queries for a few years now, and when you have performance issues, you've been updating stats and using OPTION (RECOMPILE). It's served you well, but every now and then, you hit a problem you can't solve. Your data's been growing larger, your queries are taking longer to run, and you're starting to wonder: how can I start getting better query plans?

The secret is often comparing the query plan's estimated number of rows to actual number of rows. If they're different, it's up to you – not the SQL Server engine – to figure out why the guesses are wrong. To improve 'em, you can change your T-SQL, the way the data's structured and stored, or how SQL Server thinks about the data.

This session won't fix every query – but it'll give you a starting point to understand what you're looking at, and where to go next as you learn about the Cardinality Estimator.

Featured Presentation:

Getting Better Query Plans by Improving SQL's Estimates

You've been writing T-SQL queries for a few years now, and when you have performance issues, you've been updating stats and using OPTION (RECOMPILE). It's served you well, but every now and then, you hit a problem you can't solve. Your data's been growing larger, your queries are taking longer to run, and you're starting to wonder: how can I start getting better query plans? The secret is often comparing the query plan's estimated number of rows to actual number of rows. If they're different, it's up to you – not the SQL Server engine – to figure out why the guesses are wrong. To improve 'em, you can change your T-SQL, the way the data's structured and stored, or how SQL Server thinks about the data. This session won't fix every query – but it'll give you a starting point to understand what you're looking at, and where to go next as you learn about the Cardinality Estimator.

Brent Ozar, Microsoft Certified Master of SQL Server Brent Ozar Unlimited

About Brent:
Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz and the SQL Server First Responder Kit. He loves sharing knowledge at BrentOzar.com.

REGISTER:

https://www.eventbrite.com/e/chisub-ssug-july-meeting-tickets-47926701053




PASSChapterLogo100.jpg


sql_micro_sm.gif







Andy Yun
E-Mail: SQLBek@gmail.com
Twitter: @SQLBek

Lowry Kozlowski
E-Mail: lowrykoz@gmail.com
Twitter: @lowrykoz

Chapter E-Mail: 
chisuburbanssug@sqlpass.org

 

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