May 15, 2008 at 7:02 am
Is there any need to run sp_updatestats after upgrading from SP1 to SP2?
What about DBCC_CheckDB?
Anything else needed (or not) that I haven't mentioned?
"Got no time for the jibba jabba!"
-B.A. Baracus
May 15, 2008 at 9:51 am
ahutch (5/15/2008)
Is there any need to run sp_updatestats after upgrading from SP1 to SP2?What about DBCC_CheckDB?
Anything else needed (or not) that I haven't mentioned?
I personally haven't done either when I have upgraded. I always proceeded from the assumption (probably erroneously) that if these were needed, the upgrade process would do it for me. Everything worked as expected with no loss of performance after the upgrade.
May 15, 2008 at 9:52 am
im not aware of any problems that would require an updatestats or dbcc checkdb. you may want to do the checkdb just to make sure everything is ok, but i dont think its a neccesity.
May 15, 2008 at 11:19 am
Thanks.
"Got no time for the jibba jabba!"
-B.A. Baracus
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply