• ReIndex all the Indexes from the Databases.

    EXEC sp_msforeachtable @COMMAND1="PRINT '?' DBCC DBREINDEX('?','',80)"

    GO

    Update all Statistics from the Database.

    EXEC SP_UPDATESTATS

    GO