Introduction to Indexes in SQL Server

This video is part of LearnItFirst's Transact-SQL Programming: SQL Server 2008/R2 course. More information on this video and course is available here:

http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx?an=YouTube

In this video, the discussion shifts from statistics to indexes. It's the first of four back-to-back videos on indexes, and trainer Scott Whigham recommends watching them all in one sitting if possible! You'll learn about what's going on "under the hood" when working with indexes, which will help you to understand why and how they're useful.

Highlights from this video:

* The fundamentals and purpose of indexes
* What are data pages?
* What if a table has no indexes?

and much more

Category:

Science & Technology

Tags:

• sql server 2008
• r2
• t sql
• training
• instruction
• lesson
• index
• fundamental
• basic

[abduatutube]

Hey Scott,

 I have really enjoyed the first part of your video ...you mentioned you will have 3 additional videos for this series, but i couldn't find them.

Can you please post the remaining videos?

Thanks

[LearnItFirst]

@abduatutube Glad you liked the video! The additional videos you're referring to and others from this chapter and course are available at the LearnItFirst website. Go to the link in the video description and you'll find it! This video is from chapter 5. Thanks for the comment!

[torrobinson]

@sinistar99 Cannot unhear

[sinistar99]

Young Jeff Bridges does database videos?  Wow busy guy.

[baselover84]

great tutorial(s)

but why so much beating around the bush?

you talk well, but too much.