• I recommend to my clients to never EVER use Maintenance Plans for ANYTHING. All standard/routine database maintenance activities should be done using Ola.Hallengren.com's FREE, FULLY DOCUMENTED, INCREDIBLY POWERFUL/FLEXIBLE scripts!!! The only clients I have been to that did not switch to those already had full-featured home-grown scripts and jobs in place.

    Oh, and this statement:

    "You can shrug off empty database pages to compress your data files."

    sounds to me like you are recommending shrinking database/tlog files with a maintenance plan. If so, PLEASE remove that from the article or add in a HUGE caveat about how bad that practice is!!

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service