How to rebuild indexes and update statistics without a maintenance plan

Products

• IT Management Suite

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