We can use various methods to check statistics date, such as DBCC SHOW_STATISTICS or STATS_DATE, but since the release of SP1 for SQL Server 2012, I have exclusively used sys.dm_db_stats_properties to get this information.ĬREATE CLUSTERED INDEX ON. After we create the table, we will check to see when statistics last updated. We’re going to use a copy of the Sales.SalesOrderDetail table for the demo. WHERE = 'AdventureWorks2012' AND = 0) = 0ĪLTER DATABASE SET AUTO_UPDATE_STATISTICS ON Ensure that the Auto Update Statistics option is enabled: Start with a copy of the AdventureWorks2012 database, which you can download from CodePlex. I had many people ask why statistics did not update immediately after the bulk load of the 25,000 rows completed, so I want to step through the demo that I did at Summit to clarify when an automatic update will occur. The number of rows added via the bulk import was just over the limit to trigger an auto-update of statistics for the next query, which I showed.

The database had the Auto Update Statistics option enabled, and I had added almost 25,000 rows to a table with 121,000 rows. During the session I went through a demo that showed the automatic update of a statistic. During the PASS Summit in November I presented a session on Demystifying Database Statistics (if you attended Summit but missed it, you can stream it from here).

Update statistics sql server