Skip to content

asp.net,c#.net, MVC, WPF, WCF, JavaScript, JQuery, SQL Server, Interview Q&A

Search for:

Tutorials
- C#
  - Object Oriented Programming
- ASP.NET
- ASP.NET MVC
- SQL SERVER
- WCF
- WPF
- HTML
- JavaScript
- Bootstrap
Interview Q&A
Tips & Tricks
Downloads
- SQL Downloads

096. SQL Server Script to enable and disable Auto Create Statistics

November 18, 2020 Dhruv Sheth Performance Improvement in SQL, SQL Downloads, SQL SERVER, Sql Server Scripts

-- To Enable.
ALTER DATABASE Database_Name
SET AUTO_CREATE_STATISTICS ON
 
-- To Disable. 
ALTER DATABASE Database_Name
SET AUTO_CREATE_STATISTICS OFF

Related Posts:

Different ways to concatenate strings in c# | Top 6 Ways to…

Sql Server Sql server helping Script

Post navigation

Previous Post:095. SQL Server Script to change Schema of all the Tables

Next Post:097. SQL Server script to Enable and Disable Auto Update Statistics

Email Subscription

Recent Posts

Different ways to concatenate strings in c# | Top 6 Ways to Concatenate String
Label Control in WPF Tutorials step by step-2
Hello World – WPF Tutorials Step by Step – 1
Deep dive with nullable value types in c# | Nullable in c#
133. SQL Server Script to find Installation Date, time and Authentication Mode
132. SQL Server Script to find the status of Trace is running or not
131. SQL Server Script to change the Recovery Model of a Database
130. SQL Server 2012 Introduced dm_db_log_space_usage to find a Log size
129. SQL Server Script to Enable and Disable XP_CMDSHELL Configuration
128. SQL Server Script to find uncontained objects of a Database

Archives

Tags

Android (1) Android Videos (1) ASP.NET (35) asp.net Interview Questions (6) ASP.NET MVC (7) Bootstrap (5) C# (63) C# Interview Questions (43) Downloads (3) GitHub (1) Google Tools (1) HTML (4) Interview Q&A (112) JavaScript (61) JavaScript Interview Questions (52) JQuery (6) LINQ To SQL (1) Mobile Operating System (0) News (2) Object Oriented Programming (3) Operating System (0) Performance Improvement in SQL (116) Programming Videos (0) SQL Downloads (134) SQL Interview Questions (65) SQL SERVER (190) Sql Server Scripts (135) SVN (1) Tips & Tricks (1) Tutorials (154) Uncategorized (1) Video Tutorials (0) WCF (3) WCF Interview Questions (5) Web API (1) Web API Interview Questions (1) WPF (9) Youtube API (1)

WordPress Theme: Tortuga by ThemeZee.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settings ACCEPT

Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.

Necessary

Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.

SAVE & ACCEPT

Please disable your adblocker or whitelist this site!