Post reply

how to transfer statistics from one database to another ???

  • September 13, 2009 at 4:54 am

    #156209

    is there any way to do that in sql server 2005 ???

  • September 13, 2009 at 5:47 am

    #1052794

    no, and it would not make sense to do so. Use update statistics or sp_updatestats in your target database to derive correct and up to date stats foe your database

    ---------------------------------------------------------------------

  • September 14, 2009 at 7:52 am

    #1053212

    Unless the two databases were identical in every possible way, you couldn't transfer the statistics (not that you can). But if they are identical in every possible way, the generated statistics, especially from a full scan, should be so close to one another as to appear identical.

    What problem are you trying to solve?

    "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

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply