The aim of creating indexes and partitioning data in a database is to yield good performance for users. Part seven in this series looks at the enhancements to the indexing within SQL Server 2005. We begin by outlining the basic changes to the indexing compared to previous versions. We then drill into index management and show how to use the Database Tuning Advisor as the main tool to analyze indexes. Presenter:  Bryan Von Axelson, TechNet Presenter, Microsoft Corporation Bryan Von Axelson joi...

Read more