SentryOne Team Blog (blogs.sentryone.com)

Tag : stats

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.

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 : 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 3)

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