• ravisamigo (9/21/2010)


    Dear Gail Shaw,

    Thanks.

    Full backups are running on Weekend i.e, Sunday.

    Iam planning to schedule /run it (CHECKDB) on Saturday.

    Is it fine to run update statistics( sp_updatestats) after CHECKDB?please

    yes

    have one more doubt, Will statistics update automatically when index rebuilt done?

    dbcc dbreindex yes, dbcc indexdefrag, no

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