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
Nov 122015
Aaron Bertrand (@AaronBertrand) highlights three Connect items that will address some pretty important shortcomings in SQL Server statistics.
Continue Reading »May 192015
Erin Stellato (@erinstellato) of SQLskills demonstrates that, while incremental statistics can help with maintenance, they are ignored by the optimizer.
Continue Reading »May 132015
Erin Stellato (@erinstellato) demonstrates the benefits of incremental statistics in SQL Server 2014, and also outlines some unexpected behavior.
Continue Reading »Nov 042014
Erin Stellato (@erinstellato) of SQLskills explains another reason she avoids the built-in sp_updatestats procedure: it doesn't consider indexed views.
Continue Reading »Jul 112014
Erin Stellato of SQLskills shows how to use SQL Sentry Plan Explorer and SQL Sentry Performance Advisor to see automatic statistics updates.
Continue Reading »Jun 162014
Following the recent release of SQL Server 2012 Service Pack 2 and SQL Server 2014 Cumulative Update #3, SQL Sentry's Aaron Bertrand (@AaronBertrand) takes a first look at a new performance enhancement and trace flag (2453) aimed at improving cardinality estimates for table variables and table-valued parameters.
Continue Reading »
1
2