This content has been marked as final. Show 2 replies
You'll want to create a Maintenance Plan using SQL Server Management Studio. Specifically, rebuilding and reorganizing the indexes, updating the statistics, and shrinking the database. See here for more details.
Hi Brian -
The defrag script was something that existed in the Conisio days. It is now part of the upgrade.