Home Forums SQL Server 2005 Administering SQL 2000 to 2005 - Upgrade RE: SQL 2000 to 2005 - Upgrade
Summer90
SSC-Dedicated
Points: 32891
More actions
January 18, 2013 at 6:12 am
#1578672
TEST, TEST, TEST... hope you have a test environment and just aren't upgrading production.
Biggest things are:
Rebuild Indexes so optimizer sees the indexes
Update Stats 100%
CHECK Integrity, this makes sure there is no corruption