Solved

SQL SERVER 2005 auto update statistics , auto shrink

Posted on 2008-10-05
4
1,402 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Getting the 3 middle digits 4 37
Stored procedure 4 32
Why do I get extra rows when I do inner join? 12 39
Truncate vs Delete 63 105
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

785 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