Index Tuning for SQL Server
How do you pick the right indexes to add on your tables? Which indexes aren’t doing you any good, and are only slowing you down? How many indexes should a table have?
Get the answers to these questions and more in this one-hour session on SQL Server index tuning. I show how to use Dynamic Management Views (DMVs) to add, remove, and monitor your indexes.
Here’s the links referenced in the video:
- DMV query to find unused indexes – indexes that are just slowing us down every time we do an insert/update/delete
- DMV query to find missing indexes – indexes we could add to get more performance
- Index maintenance script at SQLServerPedia – defragment or rebuild your indexes for a free performance gain
- Michelle Ufford’s articles on index maintenance
And check out my other free SQL Server training videos.