Post reply

Turn off auto-stats at table level in 2005?

  • December 31, 2012 at 1:01 pm

    #272396

    Hi Folks,

    Is it possible to turn off automatic stats gathering at the table-level in SQL 2005? I want to turn off auto-stats just on one table in my DB.

    Thanks

  • December 31, 2012 at 1:35 pm

    #1572595

    Per-index. Look up Alter Index. The Norecompute setting is the setting you want.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 31, 2012 at 9:02 pm

    #1572640

    Thanks, will check it out.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply