Stats_ID

Why Not Just Create Statistics?

Erik Darling looks at why you should be more interested in up to date statistics, and also why statistics outside of indexes aren’t really the most helpful thing.

When we auto update statistics on small tables

Stats_date()

How to Identify Useful SQL Server Table Statistics

In this article, Fikrat Azizov describes the different approaches to maintaining statistics and shows how you can use the data from your servers for intelligent statistics updates.

Automatic update of outdated statistics

A Lightweight, Self-adjusting, Baseline-less Data Monitor

Can data alert us that something is going on, without baselines and thresholds?

Enhanced Index Rebuild Script

Enhanced version of Index Rebuilt Script originally written by Michelle Ufford, which now includes latest version updates and additional features.

Custom Built Statistics

Dan Holmes shows how you can create statistics exactly the way you want within the bounds of the 200 steps available.

Who Cares About Your Data?

The observation that people hear what they want to hear is not a new one, and yet the extent to which people will go out of their way to ignore or misinterpret evidence can still surprise.