SQL Server gives us signs about what's going on inside the database engine. Learn to use the Dynamic Management Views (DMVs) to find out what's happening and how you can make it faster.
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 …