Index Utilization Summary Report Script

Index Report Scripts ...

Enhanced Index Rebuild Script

Enhanced version of Index Rebuilt Script originally written by Michelle Ufford, which now includes latest version updates and additional features.

SQL Server Heaps, and Their Fragmentation

In SQL Server, heaps are rightly treated with suspicion. Although there are rare cases where they perform well, they are likely to be the cause of poor performance. If a table is likely to have a large number of changes, then it can become fragmented due to way that space is allocated and forward pointers used. How does one detect this problem? Is it significant? How does one deal with it, if necessary? Neeraj Tripathi explains.

Adaptative Files Autogrow

Set minimal autogrow values for datafiles and logfiles depending on the file size, thresholds for all databases

Index Fragmentation

Reindexing for fragmented indexes

Script will give you the list of fragemented indexes.
(For SQL 2005-2008)

Defrag All Indexes On a Database

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.

The Real World: Fragmented Disk and High PAGEIOLATCH Waits

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

No Significant Fragmentation? Look Closer…

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.

Exceptional PowerShell DBA Pt 3 - Collation and Fragmentation

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.