The following article from TechNet lists the Top Tips for Effective Database Maintenance:
http://technet.microsoft.com/en-us/magazine/cc671165.aspx
While I'm not actively administering a database, I have had control of a few in the past, and may in the future. These tips may come in handy some day.
