SQL Server 2008 Analysis Services Training Video: The Basics of E xecution Plans and SHOWPLAN

The Basics of Execution Plans and SHOWPLAN - view details
Many of the ideas in this video will be revisited in chapters 5 and 11, so expect mostly basics here - details will come in later videos. Using the query from the last video, trainer Scott Whigham discusses execution plans. How can you uncover the steps SQL Server went through to arrive at the results? What is SHOWPLAN?

Highlights from this video:What does the execution plan tell us?
How can you look at the execution plan?
Estimated Execution Plan vs. Actual Execution Plan
How does SQL Server choose indexes?
Analyzing and understanding graphical execution plansDetermining costs of the components of executionUsing SHOWPLAN

and much more Source: http://www.learnitfirst.com/Course/161/Video/2931/Execution-Plans.aspx Course: http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx Skill Level: 200 (Beginner - Intermediate) Length: 21:15 (51.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: showplan, sql server steps, execution plan, estimated, acutal, graphical, index, cost

This video comes from the SQL Server 2008 Analysis Services online training course, Transact-SQL Programming: SQL Server 2008/R2. And be sure to check out even more SQL Server Analysis Services training videos.