Whitepaper on Database Maintenance for SharePoint is now live!

Database Maintenance for Microsoft^® SharePoint^® Products and Technologies

Summary:
This paper describes the recommended maintenance strategies for the databases that host content and configuration settings for SharePoint Products and Technologies.

Link, http://go.microsoft.com/fwlink/?LinkId=111531&clcid=0x409

Abstract: 
This white paper provides information and guidelines for maintaining the databases that host Microsoft® SharePoint® Products and Technologies data and configurations. It describes and provides examples of the database maintenance tasks that we recommend when using SharePoint Products and Technologies.

Highlights:

• Check for and repair consistency errors by using dbcc checkdb
• Measure and Reduce Fragmentation
• Fine tuning index performance by setting fill factor
• Shrinking data files
• Creating SQL Server 2005 Maintenance Plans