• As far as the new CE is concerned, Kimberly Tripp blogged some days ago about options to adopt the new CE: http://www.sqlskills.com/blogs/kimberly/sqlskills-procs-analyze-data-skew-create-filtered-statistics/

    Before migrating to the new server, I would bechmark under different conditions (CE 7, CE 12) and decide whether upgrading compatibility level or not.

    -- Gianluca Sartori