Forum Replies Created

Viewing 4 posts - 16 through 19 (of 19 total)

  • RE: STATS object corruption?

    Thanks Tracey,

    yeah, the DB is set for Auto Update Stats (synchronous) already... again, I don't think it is a problem with the UPDATE STATISTICS logic (either manually executed or executed...

  • RE: STATS object corruption?

    thanks again...yeah, I ran that command as soon as I realized all the stats objects were "corrupted" or "non-operational" or whatever.

    because SQL showed the clustered index as having 0 rows,...

  • RE: STATS object corruption?

    Hey Noel,

    thanks for answering...

    no difference.

  • RE: STATS object corruption?

    Correction:

    The maintenance plan starts around 11:00pm, nightly.

    First, the REORGANIZE Index task runs. (we could change to Rebuild if appropriate)

    Then, the Update Statistics task runs

    then backup job runs.

    Sunday Night's backup job...

Viewing 4 posts - 16 through 19 (of 19 total)