Category: Statistics

Paul White dives into histograms and explains how the optimizer uses coarse alignment for cardinality estimates.
Steven Wright explains how to diagnose performance issues in Microsoft APS and Azure Data Warehouse with SentryOne Alerts and lists some custom Advisory Conditions (AC) that many people find useful...
Erin Stellato lists out all of the enhancements to statistics in SQL Server over the years, from SQL Server 7.0 all the way through to SQL Server 2017.
October 23, 2017 | | Statistics 0
Paul White whips out the debugger while showing how SQL Server derives estimates when combining multiple, single-column statistics.
August 2, 2017 | | Statistics 0
Erin Stellato goes into detail about some practical use cases for a new DBCC command in SQL Server 2014 SP2 and 2016 : DBCC CLONEDATABASE.
August 29, 2016 | | SQL Server, Statistics 0
Erin Stellato shows the combined effect of different versions of the cardinality estimator and trace flag 2389 on an ascending key model.
July 21, 2016 | | Statistics 0
Jonathan Kehayias (@SQLPoolBoy) takes a closer look at a new trace flag that allows you to process multiple concurrent statistics updates on the
Aaron Bertrand follows up on a recent post about the performance...
Dan Holmes talks about a solution he developed to manually coerce statistics to be more accurate and produce better, more predictable execution plans.
November 24, 2015 | | Statistics 0
Aaron Bertrand highlights three Connect items that will address some pretty important shortcomings in SQL Server statistics.
November 12, 2015 | Aaron Bertrand | Statistics 0
Erin Stellato of SQLskills demonstrates that, while incremental statistics can help with maintenance, they are ignored by the optimizer.
Erin Stellato demonstrates the benefits of incremental statistics in SQL Server 2014, and also outlines some unexpected behavior.
Lori Edwards continues her series on SQL Server statistics, discussing some of the finer details around keeping stats up-to-date.
April 28, 2015 | Lori Edwards | Indexes, Statistics 1
Lori Edwards (@loriedwards) continues her series on SQL Server statistics, this time showing how even up-to-date statistics can yield inaccurate estimates.
Lori Edwards continues her series on SQL Server statistics, explaining how the optimizer uses cardinality estimates.
March 5, 2015 | Lori Edwards | Statistics 3

Top Categories

See all
1 2

Get the best SQL query analysis and optimization tool – free!

  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More