SQL Server Performance


Discussion in 'Performance Tuning for DBAs' started by hooperdba, Mar 30, 2007.

  1. hooperdba New Member

    I have a weekly maintenance program that deletes around 100,000 records from various application tables.
    Question is :

    Do I need to run an sp_updatestats after this job?
    I already have updatestats selected in DB options.
  2. Luis Martin Moderator

    I believe yes.

    If I were you I'll update statistics of those tables with fullscan (night job).

    Luis Martin

    All in Love is Fair
    Stevie Wonder

    All postings are provided “AS IS” with no warranties for accuracy.

  3. hooperdba New Member

Share This Page