Jeffrey Williams-493691 (2/16/2010)
Sergei Zarembo (2/16/2010)
1) shrink all databasesReally bad idea to schedule a shrink of the databases every night. Why do this, just so the database can grow the next day, causing file fragmentation and index fragmentation?
Jeffry,
can you tell me what might be the rationale behind the daily shrinking job? Do they try to save some disk space? if so, how much of disk space (in %) can be saved this way? I need to negotiate with our DBAs on canceling this job, because it does seem to defragment my indexes badly in an Informatica ETL database I owe.
Thank you,
Sergei Z