We have just realeased a whitepaper that describes the recommended maintenance strategies for the databases that host content and configuration settings for SharePoint Products and Technologies. You can get it here. It covers:
· Checking database integrity.
· Defragmenting indexes by either reorganizing them or rebuilding them.
· Setting the fill factor for a server.
· Shrinking databases to recover unused disk space.