Just a stab at automating index maintainenance in SQL Server 2008  Read more...

Rebuilds all indexes from all databases over a specified fragmentation threshold.  Read more...

Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance.   Read more...

Defrags all indexes in select databases in 2005, 2008, and 2012.  Read more...

Script to list out all fragmented indexes for a given database, with options to only view them, reorganize them, or rebuild them in one fell swoop.   Read more...

This article decribes how defragementing a 900 GB drive assisted in addressing major performance issues on a reporting server.  Read more...

If you are relying on using 'best-practice' percentage-based thresholds when you are creating an index maintenance plan for a SQL Server that checks the fragmentation in your pages, you may miss occasional 'edge' conditions on larger tables that will cause severe degradation in performance. It is worth being aware of patterns of data access in particular tables when judging the best threshold figure to use.  Read more...

Complete script for index defragmentation and updating stats  Read more...

Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance.   Read more...

Returns Top 25 fragmented indexes complete with full object name and index name.  Read more...

Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance.   Read more...

Returns Top 25 fragmented indexes complete with full object name and index name.  Read more...

A thorough SP for rebuilding indexes.  Read more...

In this final look into his everyday essentials, Laerte Junior provides some useful scripts for the DBA that use an alternative way of error-logging. He shows how to use a PowerShell script to check and, if necessary, to defragment your indexes, write data to a SQL Server table, and change the collation for a table. Being an exceptional DBA just got a little easier.  Read more...

Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance.   Read more...

Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance.   Read more...

Routine maintenance can keep index fragmentation to a minimum—with some help from an index-defragmenting script.  Read more...

Returns Top 25 fragmented indexes complete with full object name and index name.  Read more...

This stored procedure will reindex indexes based on the fragmentation lever.  Read more...

This article describes how an index gets fragmented and the steps which a DBA can take to fix index fragmentation  Read more...