How can I Check that whether Automatic Statistic
Update is Enabled or not?
The
following query can be used to know if Automatic Statistic Update:
SELECT is_auto_create_stats_on,is_auto_update_stats_on
FROM sys.databases
WHERE name =‘YOUR DATABASE NAME
FROM sys.databases
WHERE name =‘YOUR DATABASE NAME
No comments :
Post a Comment