Question : Is there a way to look at the complete history of growth and shrink events for the last […]
Tag: shrink
Is DBCC SHRINKFILE better than DBCC SHRINKDATABASE? [duplicate]
Question : This question already has answers here: What is the difference between Shrink Database and File? (3 answers) Closed […]
DBCC ShrinkFile EmptyFile fails due to system table SYSFILES1
Question : In following a recommendation from our new storage vendor, I’m trying to split up some large & busy […]
Reduce pre-allocated disk space
Question : We have a reporting SQL (2014 R2 Enterprise) system with a Reporting and Staging DB on it. The […]
Finding extents of Oracle BIN$ segments
Question : I am looking for information on recyclebin extents. When dropping a table its segments are renamed to ‘BIN$…’ […]
Shrinking VARCHAR with MODIFY: data alignment and potential for data loss
Question : I’m using MODIFY to change (shrink) a number of VARCHAR fields of various lengths in various tables. In […]
MS SQL Server: DBCC ShrinkDatabase – Does it really not shrink the database below the minimum size?
Question : Per Microsoft’s documentation on DBCC ShrinkDatabase command, it shouldn’t shrink the database below it’s “minimum size”. But when […]
Fix transaction log file after database update
Question : I have a databases that are regularly (monthly) updated. An update includes a lot of new or changed […]
Shrink data MDF file on server running on low disk space
Question : Before proceeding, I know the cons of doing this and have read many questions on same. But since […]
When should I use the shrink option
Question : I have seen a lot of blogs stating that shrinking is not a good habit as it will […]