Bill Baer as a new whitepaper on database management for SharePoint. This is a must read for SharePoint admins.
Some highlights from the paper:
- rebuild and reorganize (reindex) the clustered index is what defragments a table.
- reindex = defragment
- In order to avoid a huge performance hit, do not set maintenance plans to shink the db.
- be prepared - maintenance plans can be long running processes.