Category : Statistics - SentryOne Team Blog

Category: Statistics

Erin Stellato : UPDATEs to Statistics

Erin Stellato : UPDATEs to Statistics

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.

Paul White : Cardinality Estimation : Combining Density Statistics

Paul White : Cardinality Estimation : Combining Density Statistics

Paul White (@SQL_Kiwi) whips out the debugger while showing how SQL Server derives estimates when combining multiple, single-column statistics.

Erin Stellato : Expanding DBCC CLONEDATABASE

Erin Stellato (@erinstellato) goes into detail about some practical use cases for a new DBCC command in SQL Server 2014 SP2 and 2016 : DBCC CLONEDATABASE.

Erin Stellato : Trace Flag 2389 and the new Cardinality Estimator

Erin Stellato shows the combined effect of different versions of the cardinality estimator and trace flag 2389 on an ascending key model.

Jonathan Kehayias : Improved Support for Parallel Statistics Rebuilds

Jonathan Kehayias (@SQLPoolBoy) takes a closer look at a new trace flag that allows you to process multiple concurrent statistics updates on the same table.

Dan Holmes : Custom Built Statistics

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.

Aaron Bertrand : Please help improve SQL Server statistics!

Aaron Bertrand (@AaronBertrand) highlights three Connect items that will address some pretty important shortcomings in SQL Server statistics.

Erin Stellato : Incremental Statistics are NOT used by the Query Optimizer

Erin Stellato (@erinstellato) of SQLskills demonstrates that, while incremental statistics can help with maintenance, they are ignored by the optimizer.

Cool Features of SQL Server 2014: Improved Cardinality Estimates

COOL FEATURES OF SQL SERVER 2014: IMPROVED CARDINALITY ESTIMATES With all the cheerleading and the steady drumbeat of new features being released to Azure, it's easy to lose track of the many cool and valuable new features released in the on-premises version of SQL Server. One of the crown jewels of SQL Server, the cardinality

Erin Stellato : Improving Partition Maintenance with Incremental Statistics

Erin Stellato (@erinstellato) demonstrates the benefits of incremental statistics in SQL Server 2014, and also outlines some unexpected behavior.

Statistics – What, why and how (Part 4)

Lori Edwards (@loriedwards) continues her series on SQL Server statistics, discussing some of the finer details around keeping stats up-to-date.

Statistics – What, why and how (Part 3)

Lori Edwards (@loriedwards) continues her series on SQL Server statistics, this time showing how even up-to-date statistics can yield inaccurate estimates.

Statistics – What, why and how (Part 2)

Lori Edwards (@loriedwards) continues her series on SQL Server statistics, explaining how the optimizer uses cardinality estimates.

Statistics – What, why and how (Part 1)

Lori Edwards (@loriedwards) starts a new series on statistics in SQL Server. In her first post, she discusses what they are and how they are created.

Erin Stellato : Another Reason to Avoid sp_updatestats

Erin Stellato (@erinstellato) of SQLskills explains another reason she avoids the built-in sp_updatestats procedure: it doesn't consider indexed views.