Abstract

Attendees will be introduced to the wealth of data contained within the execution plans generated by SQL Server. From the simplest "SELECT *" query to complicated joins, the icons and properties that allow you to understand what is occuring within your query will be explained. You will leave knowing what kinds of execution plans you have available and what they can be used for. You'll learn about graphical exeuction plans; what do the icons mean and how are they related; how much information is available and how to access and interpret it. All this information will be used to help you understand what's happening within your queries so that you can identify and fix poor performance in your own environment. 

Presenter Bio:

Grant Fritchey, Microsoft SQL Server MVP, works for an industry-leading engineering and insurance company as a principal DBA. he's done development of large-scale applications in languages such as Visual Basic, C#, and Java, and has worked with SQL Server since version 6.0. Grant spends a lot of time involved in the SQL Server community, including speaking, blogging, and he is an active participant int the SQLServerCentral.com forums. He is the author of SQL Server Execution Plans (Simple Talk Publishing, 2008) and SQL Server Query Performance Tuning Distilled (Apress, 2008).

Audio:

Computer audio will be used for this presentation