SentryOne Team Blog (blogs.sentryone.com)

Tag: partitioning

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.

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.