InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 09:39:19 GMT20http://www.sqlservercentral.com/Forums/Topic1382244-391-1.aspxStewart. thanks for your ideas and for the post about SS 2012 and its' new features for updating stats.My instance is 2008 so I'll probably leave the UPDATE STATISTICS in my maint. plan, just to be sure they are nice and tidy.Bill in the USAThu, 08 Nov 2012 20:39:19 GMTdbaforeverhttp://www.sqlservercentral.com/Forums/Topic1382244-391-1.aspxfor ease of reference:[url]http://www.microsoft.com/casestudies/Microsoft-SQL-Server-2012-Enterprise/Microsoft-IT/Microsoft-Ensures-Smooth-Operation-of-ERP-System-and-Cuts-Disaster-Recovery-Time/710000000493[/url][url]http://blogs.msdn.com/b/saponsqlserver/archive/2011/09/07/changes-to-automatic-update-statistics-in-sql-server-traceflag-2371.aspx[/url]Thu, 08 Nov 2012 00:14:23 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic1382244-391-1.aspxUsually, SQL takes care of the UPDATE Statistics automatically.However, there may be situations where this does not occur, e.g. when the number of UPDATEd / INSERTed / DELETEd rows does not reach or exceed the specified threshold (default 20%, changable from SQL2008R2 SP1 using trace flag 2371) for auto-updates (especially on large tables)Thu, 08 Nov 2012 00:08:57 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic1382244-391-1.aspxMy 2008 R2 database has Auto Create Statistics and Auto Update Statistics both set to TRUE.Is it necessary to also perform UPDATE STATISTICS on every table in my Maint Plan?Thanks, BillWed, 07 Nov 2012 20:45:49 GMTdbaforever