How to rebuild indexes and update statistics without a maintenance plan

book

Article ID: 178513

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

 

Resolution

Question
Is it possible to rebuild indexes and update statistics on SQL Server Express (without needing to use a maintenance plan)?

Answer
 

Yes,

1.) Run the attached SQL query

 

2.) Copy the columns "Index Script" and "Update Statistics Script" into another SQL query window

 

3.) Run the created SQL scripts

 

Attachments

DefragIndexes2005.sql get_app
DefragIndexes2005.sql get_app