• I use : exec sp_MSforeachtable @command1 = "dbcc dbreindex ( '?' ) "

    I use the simple recovery mode (it's a data warehouse), but still find the dbcc shrinkdatabase important.  I always thought the log got so big because I was reindexing every table in a transaction.  But since I am able to keep enough free disk available, I have avoided reworking this job to just do a few tables at a time.