• One thing that you forgot to mention, when rebuilding the indexes you can specify a fill factor for the index.  This is helpful if you have a clustered index where the new record will be inserted between existing records.  Not as helpful, when all new records are inserted at the end of the table.