Viewing 5 posts - 1 through 6 (of 6 total)
I performed the steps in this thread in an effort to alleviate the performance issue. The user states the issue is still present.
A couple of things to note:
1. Is there...
October 10, 2005 at 7:53 am
Thanks, Rudy. There's 230 user tables in this database. I'm not really sure which tables had data archived, so I'm going to have to update statistics for all of them. ...
September 22, 2005 at 2:01 pm
Does UPDATE STATISTICS lock the table? I checked Books Online but did not see anything specific to locking.
September 22, 2005 at 1:31 pm
Just to confirm - you're saying I should run UPDATE STATISTICS and sp_recompile now? Then, when I have time in the near future, run the DBCC SHOWCONTIG and resolve the fragmentation...
September 21, 2005 at 3:04 pm
Viewing 5 posts - 1 through 6 (of 6 total)