Technet Spotlight On Demand Video - Kimberly L. Tripp - Indexing De-fragmentation with SQL Server 2005

Even when 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. Index fragmentation can negatively impact query performance, require more IOs in large scans and even require more time and space for backups. The effects fragmentation ripple through the database; did you know there are multiple ways to defragment? Did you know that each method provides different pros and cons in terms of maintenance, availability, log space and time? Are you aware of the new features offered by SQL Server 2005 that can offer improved availability while defragmenting tables? Watch this session to make your indexing best practices complete and keep your performance optimal over time.

https://www.microsoft.com/emea/spotlight/sessionh.aspx?videoid=30

Comments

• Anonymous
  January 01, 2003
  Where can I find the scripts that Kimberly used in the video?