DB Options: Auto Create Incremental Statistics ON

By | 2020-02-18

In this video we cover the next database option which is AUTO CREATE INCREMENTAL STATISTICS. This option is useful when the database has partitioned tables. It allows the DBA to update stats by merging the updated stats for the partition in question with existing stats. In this way DBA are able to reduce the overhead of updating the stats on large tables. If not enabled an update to stats will require resampling on the entire table even if historical data has not changed. This results in wasted resources since we don’t gain any new info for old records that have not changed. Even if your database doesn’t contain partitioned tables it is advisable to enable this feature since it causes no harm when tables aren’t partitioned but provides benefits when tables are.

https://youtu.be/8yS24q-dFHo

Need more information? Visit https://www.enabledbusinesssolutions.com

To know more about Jayanth Kurup visit http://www.jayanthkurup.com

Jayanth is a Microsoft SQL Server trainer / consultant with over 15 years’ experience. He has worked with companies like Microsoft, IBM, HCL, Wipro, WellsFargo, Zeomega and many more. He is based out of Bangalore and a very active member of the SQL Server Community. In this channel he covers complex topics related MS SQL Server , PowerBI , Azure , AWS , Powershell, SSIS , SSAS , SSRS , Machine Learning , AI , etc

You can also reach Jayanth via his LinkedIn profile below www.linkedin.com/in/jayanth-kurup

Category: Databases

About Jayanth Kurup

This post was written by Jayanth Kurup. A Microsoft SQL Server Consultant and Trainer based out of Bangalore, India. Jayanth has been working on MS SQL Server for over 15 years. He is a performance tuning and Business Intelligence expert. Having worked with companies like Microsoft, DELL, Wells Fargo, Thomson Reuters and many other fortune 100 companies. Some other technologies Jayanth works on include Microsoft Azure, PowerBI, Python and AWS. When he isn’t consulting or training, Jayanth like to travel, paint and read. He is also very active in social causes and the founder of Enabled Business Solutions. Visit his company by clicking the link in the menu or email him directly.