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.