Home Forums SQL Server 2008 SQL Server 2008 Administration Maintaining Statistics RE: Maintaining Statistics
Igor Micev
SSC-Dedicated
Points: 33109
More actions
May 2, 2013 at 9:17 am
#1611928
Hi,
As you said you have big tables, then enabling trace flag 2371 can be of asset for your databases. See this
http://blogs.msdn.com/b/saponsqlserver/archive/2011/09/07/changes-to-automatic-update-statistics-in-sql-server-traceflag-2371.aspx
Regards,
IgorMi
Igor Micev,My blog: www.igormicev.com