Forum Replies Created

Viewing 5 posts - 1 through 6 (of 6 total)

  • RE: Data purge follow-up

    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...

  • RE: Data purge follow-up

    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. ...

  • RE: Data purge follow-up

    Does UPDATE STATISTICS lock the table?  I checked Books Online but did not see anything specific to locking.

  • RE: Data purge follow-up

    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...

  • RE: Data purge follow-up

    Good stuff.  Thanks very much!

Viewing 5 posts - 1 through 6 (of 6 total)