Unable to declaratively disable "auto-statistics" update on tables
At database level,
we can disable "Auto Update Statistics"
ALTER DATABASE <database>
SET AUTO_UPDATE_STATISTICS ON;
and determine current status
select databasepropertyex('sam', "IsAutoUpdateStatistics')
At the Table level:
we can disable stat
EXEC sp_autostats <object-name>, 'OFF';
and determine stats
EXEC sp_autostats <object-name>
But, it appears that sp_autostats' true granularity is at Index\Statistics Level.
When setting it for a table, it seems to apply to all current\existing Indexes\Statistics.
When Querying it, it returns information for all existing Indexes\Statistics.
In some use cases, one might want to declaratively specify that Statistics should never be automatically re-calibrated for specific table(s).
Also, one should be able to query for same, that is determine at a table object, and not Database nor Statistics, whether Statistics are being auto maintained.
Not being able to determine if it is a table level, one just as to keep issuing sp_autostats and pass in the table's name.