Viewing 4 posts - 16 through 19 (of 19 total)
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...
March 3, 2009 at 1:54 pm
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,...
March 3, 2009 at 1:42 pm
Hey Noel,
thanks for answering...
no difference.
March 3, 2009 at 10:49 am
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...
February 24, 2009 at 7:39 pm
Viewing 4 posts - 16 through 19 (of 19 total)