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 when monitoring these systems.
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 (@SQL_Kiwi) whips out the debugger while showing how SQL Server derives estimates when combining multiple, single-column statistics.
Erin Stellato shows the combined effect of different versions of the cardinality estimator and trace flag 2389 on an ascending key model.
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.
Aaron Bertrand (@AaronBertrand) highlights three Connect items that will address some pretty important shortcomings in SQL Server statistics.
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 (@erinstellato) demonstrates the benefits of incremental statistics in SQL Server 2014, and also outlines some unexpected behavior.