SQL Server Statistics internals Archives

SQL Server – AUTO UPDATE STATS ASYNCHRONOUSLY database option

June 5, 2012September 30, 2014 - by Amit Bansal - 5 Comments.

Hi Friends, The optimizer relies heavily on statistics to produce an efficient execution plan. There are many environments where I have seen that AUTO CREATE STATS and AUTO UPDATE STATS is …

SQL Server

SQL Server – Statistics object name _WA_Sys_00000003_1EF99443. Let us decode

June 1, 2012September 30, 2014 - by Amit Bansal - 8 Comments.

Hi Friends, A light blog for the weekend ! Many of you know that statistics get created automatically provided AUTO_CREATE_STATISTICS is turned on. But have you observed the names of these …