Preserving SQL Server Performance through Index Maintenance

Tech*Ed Conference Session, 75 minutes
Written/Presented by Kimberly L. Tripp, SQLskills.com

Even if properly created (and with the right strategies based on data usage patterns) indexes can lose their effectiveness over time due to fragmentation through inserts, updates and deletes. In this session you will learn the effect of data modifications on indexes and how to clean up the fragmentation. Did you know there are multiple ways? Did you know that each method provides different pros and cons in terms of maintenance and availability? Did you know there are index maintenance changes coming in SQL Server 2005? You will after this session!