Earlier this year, I finally passed the Microsoft Certified Master (MCM) for SQL Server 2008 certification. In the process of preparing for the MCM lab portion, I did a lot of studying. One of the my key resources, were the MCM Readiness Videos that SQLSkills put together a couple years back.
The thing is, even if you aren’t interested in the MCM, you should still be paying attention to these videos. They provide some of the best FREE training on SQL Server available. There are more than 50 videos available, so I thought I would highlight five that dealt with indexing that you should take a loot at…
- Indexing Strategies - How do the indexes fit together and what can you expect from them. The aim for indexes is boost performance, this video shows you how to develop a strategy for that goal.
- Index Analysis - Want to know how to figure out if you have the right indexes, this is what this training brings to you. Also, taking a look at how to determine when you are missing indexes.
- Index Internals - Want to know how indexes stored at the physical level. Maybe a little too nerdy for some, but knowing how it works will let you know why it behaves in certain ways.
- The Clustered Index Debate - Looks at the structures available for storing tables and how they interact with non-clustered indexes. Information on how to know if you have the right, or should have, a clustered index.
- Statistics - While not specifically indexing, statistics are the driving force that lets SQL Server know when and what indexes to use. Poor or out-of-date statistics can make some of the best indexes perform poorly – this video will explain how.
If you are looking for more information on indexing. May be a few hundred pages about it, you can check out Expert Performance Indexing for SQL Server 2012. Along with that, for indexing resources from my blog, check out the index resource page.