Database Maintenance for Microsoft SharePoint Products and Technologies

Database maintenance is essential for the health and the performance of your SharePoint® Products and Technologies applications (EPM and/or MOSS).

Check these white papers:

Database Maintenance for Microsoft® SharePoint® Products and Technologies

Planning and Monitoring SQL Server Storage for SharePoint: Performance Recommendations and Best Practices

and this KB article

How to defragment Windows SharePoint Services 3.0 databases and SharePoint Server 2007 databases (