Enhanced SQL Server Enterprise Manager

The SQL Server Enterprise Manager provides wizards for common tasks that database administrators perform, including creation of databases, tables, views, indexes, jobs, alerts, and stored procedures. The Index Tuning Wizard examines a server activity capture file and then analyzes submitted queries against a database's index configuration, suggesting new indexes. The Maintenance Plan Wizard schedules table reorganizations to add fill-factor space, updates statistics, checks table and index integrity, and runs backups.