SQL 2005 Web Training: Effectively Designing a Scalable and Reliable Database: Session 5 of 10: New Features in Indexing and Index Maintenance

Microsoft Partner Readiness: "Once an index is created, it must be maintained in production. Possibly more the system administrator�s job but effectively a database developers performance problem � an unmanaged index will slowly become fragmented over time and will begin to degrade in performance. In this session, you will learn appropriate strategies in monitoring fragmentation, monitoring index usage and maintaining indexes for better performance. MSDN Web Seminar"