How to Enable Automatic Statistic Update on Database

After putting good indexes and optimizing the query, I could not achieve an optimized performance and I still received an unoptimized response from the SQL Server. On examination, I figured out that the culprit was statistics. The database that I was trying to optimize had auto update of the statistics was disabled.

Once I enabled the auto update of statistics, the database started to respond as expected. If you ever face situation like this, please do the following:

1) Enable Auto Creation of Statistics

2) Enable Auto Update of Statistics

3) Update Statistics for whole database

/* To Check the Stats of a Database */

SELECT is_auto_create_stats_on,is_auto_update_stats_on 

FROM sys.databases

WHERE name = 'DB_Name'

/* Enable Stats and Auto Update*/

--Enable Auto Create of Statistics 
ALTER DATABASE AdventureWorks SET AUTO_CREATE_STATISTICS ON;
GO
--Enable Auto Update of Statistics 
ALTER DATABASE AdventureWorks SET AUTO_UPDATE_STATISTICS ON;
GO
--Update Statistics for whole database 
EXEC sp_updatestats
GO