Reducing the size of a reporting database starts with compression, archiving, and index review; shrinking files comes last.
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.
SQL SERVER – Shrinking Truncate Log File – Log Full – Part 2
About a year ago, I wrote SQL SERVER – Shrinking Truncate Log File – Log Full. I was just going through some of the earlier posts and comments.