Dan Holmes (sql.dnhlms.com) talks about a solution he developed to manually coerce statistics to be more accurate and produce better, more predictable execution plans.
Continue Reading »Nov 242015
Feb 192015
Benjamin Nevarez (@BenjaminNevarez) gives a very early look at a feature coming soon to Azure SQL Database and SQL Server vNext: the Query Store.
Continue Reading »Feb 142014
Benjamin Nevarez (@BenjaminNevarez) takes a close look at the new incremental statistics feature in SQL Server 2014.
Continue Reading »Dec 192013
Benjamin Nevarez (@BenjaminNevarez) gives us some insight into the new cardinality estimator in SQL Server 2014 – both how it works as well as how to keep the functionality of the current version of the estimator.
Continue Reading »