SQL Server 2008 Analysis Services Training Video: How SQL Server Uses Indexes in Queries

How SQL Server Uses Indexes in Queries - view details
The visualizations in this video will help clarify all of these index-related concepts you've been learning in the last two videos, and introduce some new ones. You'll look at the format of a typical SQL Server page, an index page, and learn about reading a B-Tree. Scott demonstrates working with indexes using several examples, including an intentionally poorly designed table. What happens when you ask for a specific row or subset of rows over a table with no indexes?

Highlights from this video:A typical SQL Server page
Understanding a B-Tree
The row locator
What is a Seek?Figuring out what SQL's execution plan will be for a query based on the search argument
and much more Source: http://www.learnitfirst.com/Course/161/Video/2959/Indexes-Queries.aspx Course: http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx Skill Level: 200 (Beginner - Intermediate) Length: 16:00 (30.9MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: index, row locator, b tree, seek, search argument, sarg

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.