Turn off auto-stats at table level in 2005?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » Turn off auto-stats at table level in 2005?

Turn off auto-stats at table level in 2005?

Rate Topic

Display Mode

Topic Options

Author

Message

M_E_K

Posted Monday, December 31, 2012 1:01 PM

SSC Rookie

Group: General Forum Members
Last Login: Friday, April 05, 2013 8:15 AM
Points: 25, Visits: 85

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

Post #1401488

GilaMonster

Posted Monday, December 31, 2012 1:35 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:30 AM
Points: 37,742, Visits: 30,021

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

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1401491

M_E_K

Posted Monday, December 31, 2012 9:02 PM

SSC Rookie

Group: General Forum Members
Last Login: Friday, April 05, 2013 8:15 AM
Points: 25, Visits: 85

Thanks, will check it out.

Post #1401542

« Prev Topic | Next Topic »

Permissions