Solved

SQL SERVER 2005 auto update statistics , auto shrink

Posted on 2008-10-05
4
1,404 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

734 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