Rebuild Indexes in SQL Server

Overview

There are a situations when you might need to run a manual index rebuild on your SQL Server:

• updates - before running an update (this is important on large systems to minimize the update time)
• slow searches - when you experience slow searches it means that your automated maintenance job does not run index rebuild (recommended every week)

Run a manual index rebuild

This is how you can run index rebuild on the tables:

Step 1 - Open SQL Server Management Studio

Step 2 - Connect to the database server and

Step 3 - In the left tree find Databases / <DB> / Tables 

Step 4 - Open the dbo.Table table, right click Indexes and run Rebuild All