Albuquerque SQL Server User Group

What's Happening?

Next Meeting: Fri, Jan 11 2019

January Meeting: Execution plans … where do I start? - with Hugo Kornelis

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.meetup.com/Albuquerque-SQL-Server-User-Group/events/257864018/

The Albuquerque SQL Server User Group (ABQSQL) will be having its next meeting on Friday, January 11th from 11:30 AM to 1:00 PM at Hospital Services Corporation, 7471 Pan American Freeway NE.

Hugo Kornelis from the Netherlands will be sharing his insights about analyzing SQL Server execution plans. Please join us for his remote presentation “Execution plans … where do I start?”. Ask Hugo your SQL questions, get to know your peers, and have lunch on us!

Presentation description: "SQL (the language) is not a third generation language, where the developer tells the computer every step it needs to take. It is a declarative language that specifies the required results. SQL Server itself will figure out what steps it takes to get to those results. Most of the time, that works very well.

But sometimes it doesn’t. Sometimes a query takes too much time. You need to find out why, so you can fix it. That’s where the execution plan comes in. In the execution plan, SQL Server exposes exactly which steps it took for your query, so you can see why it’s slow.

However, execution plans can be daunting to the uninitiated. Especially for complex queries. Where do you even start?

In this session you will learn how to obtain execution plans. and how to start reading and understanding them."

Attend this FREE SQL training event!

Kindly RSVP so we know how much pizza we should buy!

PASS membership is not a prerequisite to attend this or any other monthly meeting of the Albuquerque SQL Users Group, however, you can enjoy many benefits of being a member by signing up for a FREE PASS membership at http://www.pass.org/.

When

iCal
UTC : Fri, Jan 11 2019 18:30 - 20:00
Event Time : Fri, Jan 11 2019 11:30 - 13:00 (UTC-07:00) Mountain Time (US & Canada)
Your Local Time: Fri, Jan 11 2019 18:30 - 20:00

Where

7471 Pan American Freeway West NE
Albuquerque, New Mexico

Direction: None

Featured Presentation

Execution plans … where do I start?

Speaker: Hugo Kornelis, Database Consultant JuTi Holding BV

Summary: SQL (the language) is not a third generation language, where the developer tells the computer every step it needs to take. It is a declarative language that specifies the required results. SQL Server itself will figure out what steps it takes to get to those results. Most of the time, that works very well. But sometimes it doesn’t. Sometimes a query takes too much time. You need to find out why, so you can fix it. That’s where the execution plan comes in. In the execution plan, SQL Server exposes exactly which steps it took for your query, so you can see why it’s slow. However, execution plans can be daunting to the uninitiated. Especially for complex queries. Where do you even start? In this session you will learn how to obtain execution plans. and how to start reading and understanding them.

About Hugo: Hugo Kornelis is an established SQL Server community expert who spends a lot of time at various conferences. He is author of "the Execution Plan Reference" (sqlserverfast.com/epr), blogger, technical editor of a variety of books, and Pluralsight author. He was awarded SQL Server MVP and Data Platform MVP 11 times (2006 - 2016). When not working for the community, he is busy at his day job: freelance database developer/consultant. Hugo has over 20 years of SQL Server experience in various roles. He loves to write and tune complex queries, but he also has a strong database design background.

Attachments

Please be sure to check out our Meetup.com page, and RSVP there for our monthly meetings.

PASS membership is not a prerequisite to attend this or any other monthly meeting of the Albuquerque SQL Users Group, however, you can enjoy many benefits of being a member by signing up for a FREE PASS membership at http://www.pass.org/.

PASSChapterLogo100.jpg  

 

 


 

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