1
December 5, 2012 2:00 PM
Posted by: Denny Cherry
Auto Update Statistics Asynchronously, Auto Update Stats, Database, Database Administration, SQL, SQL Server, Statistics, Tables
Databases With Large Tables Should Use Auto Stats Async Update Feature
Posted by: Denny Cherry
Auto Update Statistics Asynchronously, Auto Update Stats, Database, Database Administration, SQL, SQL Server, Statistics, TablesA pretty cool feature that was introduced in SQL Server 2008 R2 SP1 is the ability to change the auto stats algorithm from the default of 20%+500 rows to a sliding scale. ...
1 Comment
RSS Feed
Email a friend
