Find auto shrink and auto close settings, generate reviewed correction commands, inspect model, and check the effects of prior shrink work.
Why DBCC SHRINKFILE Crawls and How to Watch Its Progress
Explain why DBCC SHRINKFILE can take hours, monitor percent_complete and waits, and use TRUNCATEONLY before small steps.
Reducing the Size of a Reporting Database
Reducing the size of a reporting database starts with compression, archiving, and index review; shrinking files comes last.
Reclaiming Space Quiz: Does Deleting Rows Shrink the File?
This Reclaiming Space Quiz asks what happens to the data file after you delete half the rows of a big table. The file keeps its size, and the space stays free inside it. A tested script shows the numbers, then what a shrink costs.
SQL SERVER – What the Business Says Is Not What the Business Wants
Let us discuss about What the Business Says Is Not What the Business Wants. Steve raised a very interesting question.
SQL SERVER – Shrinking Database NDF and MDF Files
Previously, I had written a blog post about SQL SERVER. I am posting this blog post here about Shrinking Database.
Checking Every Database for Risky Settings
Find risky settings across every SQL Server database, including AUTO_SHRINK, AUTO_CLOSE, page verification, recovery model, and ownership.