How to rebuild indexes and update statistics without a maintenance plan

HOWTO10880

Last Updated April 22, 2015

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

Imported Document ID: HOWTO10880

Legacy ID: 50313

Thanks for your feedback. Let us know if you have additional comments below. (requires login)