SQL Server optimizer Archives

SQL Server Architecture Part 2: The Relational Engine

January 28, 2014September 10, 2014 - by Edominer Peoplewareindia - 3 Comments.

In the previous article of this series, we discussed about the overall SQL server architecture and the Network Interface (specially). In this article we’ll discuss about the next, but very important …

SQL Server

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 …