statistics

Not all stats should be auto-updated

August 29, 2024 Andy 1

Statistics auto-updates are generally a good thing–auto-update of statistics is the default behavior in SQL Server. Having the freshest information about the data “shape” helps to inform the best selection of an execution plan for queries. Except for when it doesn’t. Because It Depends™️ Let’s … [Read More]

Auto-update-stats

sp_autostats: object-level auto update statistics

December 15, 2015 Andy 1

In SQL Server, auto-update statistics is a database level setting. It’s right  there: I’m not going to say whether I think Auto Update Statistics should be on or off. Instead, I’m going to argue that there are definitely scenarios when you want to have this on … [Read More]