When many DBAs talk about index maintenance they are referring to the process of rebuilding or reorganizing indexes to reduce fragmentation. Many use a script much like I do to determine the set of indexes to defragment based on the size of the table and the percent of fragmentation, etc. I don’t want to talk… Continue reading Proactive Index Maintenance