SharePoint Database Maintenance
Microsoft has released a database maintenance guide for administrators.
Its worth a read and easy to follow. Only a few pages long, it details a step by step process on creating a SharePoint SQL Maintenance Plan.
Download it here.