Microsoft’s Paul Randal has a good post with a list of common sense practices for maintaining very large databases. I have personally seen the problems that heavy index maintenance can cause when database mirroring is turned on (especially if you have less IO capacity on the mirror side than on the principal side).
At any rate, this is a good best practices list.
Technorati Tag: SQL Server
Glenn Berry's SQL Server Performance 