Index Tuning Part 4: Outsmarting the Wizards
by Brent Ozar
SQL Server’s Dynamic Management Views (DMVs) can tell you what indexes need to be added – without doing any tracing or performance monitoring. In this video tutorial, we’ll show you how.
Get the Flash Player to see the wordTube Media Player.
In the podcast, we mention a few links:
- Script to find missing indexes
- T-SQL Script Library
- Kimberly Tripp on spring cleaning for your indexes
If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:
- MP4 (Apple) Video Feed
- WMV (Microsoft) Video Feed
- MP3 Audio-Only Feed
- Zune One-Click Subscribe for Video
- Zune One-Click Subscribe for MP3
You can also download this video to watch it later: