Solved

Auto Shrink?

Posted on 2009-07-03
1
410 Views
Last Modified: 2012-05-07
Should you auto shrink sql server 2000 databases?
0
Comment
Question by:Bob Schneider
1 Comment
 
LVL 12

Accepted Solution

by:
kevin_u earned 500 total points
Comment Utility
If you auto shrink, you may end up getting hit by a performance slow down, when the shrink starts.  Since its "auto" you don't know when it will be.

I'd suggest you create a mantenance plan to do the shrinking and any other re-indexing, update statistics, etc at a time of your choosing.  Let SQL Server Agent be your friend.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

763 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

6 Experts available now in Live!

Get 1:1 Help Now