{"id":836,"date":"2015-07-21T15:30:41","date_gmt":"2015-07-21T14:30:41","guid":{"rendered":"http:\/\/dotnetsql.info\/net-sql\/?p=836"},"modified":"2015-08-13T12:17:23","modified_gmt":"2015-08-13T11:17:23","slug":"how-do-you-check-if-automatic-statistic-update-is-enabled-for-a-database","status":"publish","type":"post","link":"http:\/\/dotnetsql.info\/net-sql\/index.php\/how-do-you-check-if-automatic-statistic-update-is-enabled-for-a-database\/","title":{"rendered":"How do you check if automatic statistic update is enabled for a database?"},"content":{"rendered":"

The following query can be used to determine if Automatic Statistic update is enabled:<\/p>\n

SELECT is_auto_create_stats_on,\u00a0is_auto_update_stats_on<\/p>\n

FROM sys.databases<\/p>\n

WHERE name <\/strong>=’YOUR DATABASE NAME HERE’<\/p>\n

Thanks for reading this article,<\/strong><\/p>\n

Next steps :<\/strong><\/p>\n

    \n
  1. Add this script to your database toolkit<\/strong><\/li>\n
  2. Share this with your colleagues because Sharingis Learning<\/strong><\/li>\n
  3. Comment below if you need any assistance<\/strong><\/li>\n<\/ol>\n

    Powered by CodeReview – Let’s make it Better!<\/a><\/strong><\/em><\/p>\n

    Share this:<\/h3>