098. SQL Server Script to Enable and disable Auto Update Statistics Asynchronously

Performance Improvement in SQL, SQL Downloads, SQL SERVER, Sql Server Scripts
-- To Enable.
ALTER DATABASE Database_Name
SET AUTO_UPDATE_STATISTICS_ASYNC ON
 
-- To Disable. 
ALTER DATABASE Database_Name
SET AUTO_UPDATE_STATISTICS_ASYNC OFF