We use SQL Server 2008 Uber Edition (which it is compared to SQL Server 2005) . I ran the query to defragment the indexes. I noticed in SQL Managment Studio that there are options under the Maintenance Plan that deal with maintaining the indexes for optimal performance.
Right now I just back up the database and run the clean-up tasks to for backups older than 4 weeks. I'm proud of myself because I even got the e-mail function to work to send our NOC an e-mail when database backups complete or fail! 
Should I implmenent any more features of SQL Management Studio to help tweak the database and keep it at optimal efficiency?
