CODEWITHSUNDEEP
sql-serversql-server-2008
GibboK
GibboK

Reputation: 73988

ms sql 2008 r2 rebuild index automatically

I have a db in MS SQL 2008 R2 I would like to know if there exists some utility (in MS Management Studio) or other which can automatically rebuild my indexes for a database.

By automatically I mean rebuilding once at week or at regular interval of time.

Upvotes: 1

Views: 4903

Answers (2)

Tim Harkin
Tim Harkin

Reputation: 180

Under the Management folder, there is a Maintenance Plan folder. You can right-click on that and select the Maintenance plan wizard.

If you want to go beyond that take a look here for widely used, highly flexible scripts that go well beyond the wizard: http://ola.hallengren.com/

Upvotes: 4

Kermit
Kermit

Reputation: 34062

See How to: Rebuild an Index (SQL Server Management Studio) and Rebuild Index Using Transact-SQL.

Upvotes: 2

Related Questions