SQL Statistics Archives - Page 2 of 2

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.

Erin Stellato ◆ May 13, 2015

3

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.

Erin Stellato ◆ November 4, 2014

2

Another Way to View Automatic Updates to Statistics

Erin Stellato of SQLskills shows how to use Plan Explorer and SQL Sentry to see automatic statistics updates.

Erin Stellato ◆ July 11, 2014

5

New Trace Flag to Fix Table Variable Performance

Following the recent release of SQL Server 2012 Service Pack 2 and SQL Server 2014 Cumulative Update #3, SQL Sentry's Aaron Bertrand (@AaronBertrand) takes a first look at a new performance enhancement and trace flag (2453) aimed at improving cardinality estimates for table variables and table-valued parameters.

Aaron Bertrand ◆ June 16, 2014

11

How Automatic Updates to Statistics Can Affect Query Performance

Erin Stellato (@erinstellato) of SQLskills performs some tests to evaluate the effect end users might expect from automatic updates to statistics.

Erin Stellato ◆ May 1, 2014

4

Tracking Automatic Updates to Statistics

Erin Stellato (@erinstellato) of SQLskills walks through three methods of tracking automatic statistics updates: SQL Trace, Extended Events, and dynamic management objects.

Erin Stellato ◆ April 2, 2014

2

SQL Server 2014 Incremental Statistics

Benjamin Nevarez (@BenjaminNevarez) takes a close look at the new incremental statistics feature in SQL Server 2014.

Guest Posts ◆ February 14, 2014

6

Indexed Views and Statistics

Paul White (@SQL_Kiwi) shows some details about statistics and indexed views that may have you revisiting your code (even on Enterprise Edition).

Paul White ◆ January 3, 2014

10

A First Look at the New SQL Server Cardinality Estimator

Benjamin Nevarez (@BenjaminNevarez) gives us some insight into the new cardinality estimator in SQL Server 2014 – both how it works as well as how to keep the functionality of the current version of the estimator.

Guest Posts ◆ December 19, 2013

9

Performance Surprises and Assumptions : DATEDIFF

Aaron Bertrand (@AaronBertrand) investigates a case where two different methods of deriving an inline constant can lead to very different cardinality estimates.

Aaron Bertrand ◆ September 5, 2013

3

Understanding What sp_updatestats Really Updates

Erin Stellato (@erinstellato) of SQLskills.com dives into what sp_updatestats is really doing, and why you should avoid relying on it for perpetual maintenance on your SQL Servers.

Erin Stellato ◆ July 2, 2013

30