How to automate the SQL Server database maintenance

SQL Server provides the possibility of automating some actions/tasks to be executed periodically without user action for a good performance.

Log on SQL Server Management Studio and select Management/Maintenance Plans:

Do a right click on Maintenance Plans and select "Maintenance Plan Wizard"

Follow the steps selecting the following actions in the default order:

The maintenance tasks can be executed over one or more databases, remember to select the desired databases per task:

The attached video shows how to create a Maintenance plan as described above.