Free Webcast: Reading Execution Plans for Performance Tuning

Wednesday, January 25, 2017, 1:00 PM Eastern

EVENT SUMMARY

Webcast Overview

This will be a Beginners session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. The, we will answer questions like the following. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window?

Your registration includes:

On-demand viewing for 7 days following the event
Access to the virtual event video content

Not sure you can attend? No problem, all the video content will be available on-demand for 7 days.

SESSIONS

All times are Eastern Time Printable Schedule || Times, presenters and sessions are subject to change.

1:00 PM
-to-
1:44 PM


Track:
Room 1

Reading Execution Plans for Performance Tuning

Thomas  LaBlanc
This will be a Beginners session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. The, we will answer questions like the following. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window?


SPEAKERS

Thomas LaBlanc

Thomas LeBlanc is a Data Warehouse Architect in Baton Rouge, and uses his 25 years in IT to help develop OLTP systems with normalized databases for high-performing T-SQL systems and end-to-end dimensional data marts using SSIS, SSAS, 3rd party apps, and Excel. His SQL Server certifications include MCSA 12, MCITP 08 BI and DBA, MCITP 2005 DBA, and MCDBA 2000. As a PASS volunteer, he is currently the Excel BI VC chair and past chair of Data Arch VC and VC Mentor. Thomas has spoken at the PASS Summit for the last 4 years(2011-2014). Local work includes the Baton Rouge SQL Server User Group and assisting with four SQLSaturday’s. Bing TheSmilingDBA for more information about Thomas

Free Webcast: Reading Execution Plans for Performance Tuning

 
 
 
 
 
Updating Registration
Submitting Registration