RSS

Monthly Archives: June 2015

SQL Server 2016 Community Technology Preview 2.1 is available

Microsoft is going very fast to SQL Server 2016 last month Microsoft announced about SQL Server 2016 and you can know more information about it from here , and today microsoft release CTP 2.1 (Community Technology Preview) you can dwenoad it from here

for the Official News from Microsoft’s Information Platform you go to this link 

SQL Server 2016 CTP 2.1

SQL Server 2016 CTP 2.1

To check all my posts you godirect to my personal website or you can download this Excel sheet My Technical POSTS

View all my tips , LinkedIn Slideshare ,Youtube Channel.My posts in MSDN

 
2 Comments

Posted by on June 26, 2015 in SQL Server 2016

 

Tags: , ,

Check and Enable Automatic Statistic Update on Database Level

AS SQL Server Best Practices: Auto-Create and Auto-Update Statistics Should Be On – Most of the Time in general they are a very good thing for performance. You could try to figure out which columns need statistics, but it’s often better to let SQL Server do that for you.You can turn on the AUTO_CREATE_STATISTICS database option and SQL Server will automatically determine when it needs the Statistics and create them for you.

Check And Enable Automatic Statistic Update on all databases have this option is disable

Select ‘ALTER DATABASE [‘+Name+’] SET AUTO_CREATE_STATISTICS ON;
GO
ALTER DATABASE [‘+Name+’] SET AUTO_UPDATE_STATISTICS ON;
GO
‘ from Sys.Databases where is_auto_update_stats_on = 0 or is_auto_create_stats_on = 0

Take the Result and Execute it in another session

Update Statistics

To check all my posts you godirect to my personal website or you can download this Excel sheet My Technical POSTS

View all my tips , LinkedIn Slideshare ,Youtube Channel.My posts in MSDN

 

Tags: , , ,