29Apr/110
MS SQL Server – index fragmentation – amended
From http://wp.daveheavyindustries.com/2011/02/07/ms-sql-server-index-fragmentation/
Having had to use this on a very large database, I've made some small changes to the index fragmentation statistics script. this time to include table names (object_name) as well as database_name.
7Feb/110
MS SQL Server – index fragmentation
Sometimes it doesn't make sense to rebuild all of your indexes as part of a maintenance plan. You may have mirroring running with large db tables, and your indexes may be several GB. As part of your maintenance schedule, I recommend manually finding fragmented indexes and rebuilding them yourself (or scripting this)
To do this you, you need to locate the indexes -- anything over 50% can be considered a problem.