Interview Questions, Sql Server Tutorials

How do you check if automatic statistic update is enabled for a database?

The following query can be used to determine if Automatic Statistic update is enabled:

SELECT is_auto_create_stats_on, is_auto_update_stats_on

FROM sys.databases

WHERE name =’YOUR DATABASE NAME HERE’

Thanks for reading this article,

Next steps :

  1. Add this script to your database toolkit
  2. Share this with your colleagues because Sharingis Learning
  3. Comment below if you need any assistance

Powered by CodeReview – Let’s make it Better!