SQL Server is constantly watching queries and taking notes about what indexes could have made the queries - and which ones aren't helping at all. Learn how to use the Dynamic Management Views (DMVs) to build better indexes and dump the ones you don't need.

SQL Server's Dynamic Management Views (DMVs) have some limitations. They don't reset until your SQL Server service restarts, and they don't give you good trending information. SQL Server 2008's new Management Data Warehouse improves on the DMVs, but we're not all on 2008, and we don't all …