Month: February 2012

Statistics Enhancements in SQL Server 2012

Today I want to talk about Statistics Enhancements in SQL Server 2012. As you already know SQL Server uses Statistic Objects in a database to estimate the cardinality of queries. The cardinality estimation is the input for the generation of the physical Execution Plan of a given T-SQL query. Data changes over time, data distribution …

Statistics Enhancements in SQL Server 2012 + read more