Solved

SQL SERVER 2005 auto update statistics , auto shrink

Posted on 2008-10-05
4
1,401 Views
Last Modified: 2010-04-21
Hi Experts Basically i have switched the database properties update statistics,auto shrink to true I want to understand what is the interval SQL server will auto update statistics or auto shrink .is there any interval defined or can user set that timmings.
0
Comment
Question by:Sandeepiii
  • 2
  • 2
4 Comments
 
LVL 37

Accepted Solution

by:
momi_sabag earned 300 total points
ID: 22644789
statistics are updated according to the amound of updates done to your data and according to the queries that are performed in your system
0
 

Author Comment

by:Sandeepiii
ID: 22645217
Thanks.that means it is done by sql engine and that time interval cannot be set like once or two times all decision is taken by engine based on amt of work happening.
0
 
LVL 37

Expert Comment

by:momi_sabag
ID: 22657272
exactly
0
 

Author Closing Comment

by:Sandeepiii
ID: 31503181
explanation was very precise and helpful .
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now