• TheSQLGuru (8/24/2016)


    I don't think it is still "required" but it used to be that upgrading versions mandated full-scan statistics updates on all statistics in every database migrated.

    Not at all required, but not at all a bad idea. You will get a stats update on restored statistics from an old version now. However, that means waiting for each one to come up. I'm not crazy about that approach. I like yours better.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning