Index Fragmentation
by Brent Ozar
Is index fragmentation a problem for your SQL Servers? How would you find out? Brent Ozar shows how to quickly query all of your SQL Server 2005 and 2008 instances to find out where you’ve got fragmentation.
Related wiki articles include:
- T-SQL Code Library – has scripts to help you manage your index fragmentation and other common DBA tasks.
- Index Maintenance – the scripts used in the demo video, originally written by Michelle Ufford of SQLFool.com.
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:
