Home > IT Blogs > SQL Server with Mr. Denny/

SQL Server with Mr. Denny:

auto-stats

1
October 4, 2011  7:58 PM

New SQL 2008 R2 SP1 trace flag adjusts autostats threshold



Posted by: Denny Cherry
auto-stats, SQL Server, SQL Server 2008 R2, SQL Server 2012, Statistics, Trace Flag

I recently learned about a new trace flag which has been introduced in SQL Server 2008 R2 SP1 (and SQL Server "Denali").  This trace flag, number 2371, changes the way that the SQL Server figures out when auto-stats should kick in. Up until now auto-stats was fixed to kick in every time that...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1