Index fragmentation in sql server

165

Problem

One of the main functions of a DBA is to maintain indexes. There have been several tips written about different commands to use for index rebuilds and index reorgs as well as the differences between index maintenance with SQL Server.

In addition, other tips have been written about using maintenance plans to maintain indexes on all databases.

Sql server rebuild all indexes online

One of the issues with maintenance plans is that they don’t always seem to be as reliable as you would hope and you also sometimes get false feedback on whether the task actually was successful or not. In this tip we look at a simple script that could be used to rebuild all indexes for all databases.

Solution

The one nice thing about maintenance plans is that they work across multiple databases and therefore you can push out one task to handle the same activity across all of your databases.

The problem that I have seen with maintenance plans is that sometimes they do not work as expected, therefore in this tip I provided another approach.

The script below al

rebuild index in sql server script

rebuild index in sql server for a table