
sp_autostats: object-level auto update statistics
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]