Tag Archives: Shrinking & Transactions

A Picture That Says, “Don’t Shrink!” (and other things…)

So I wrote a lot of posts around shrinking (Here, here, here). Some of my posts were turned into a wiki article on SQLServerPedia. I thought I was done posting about this but one more. I talked about why we shouldn’t do it on a regular basis. Why it should really be reserved for use […]

Manage Your Transactions (So They Don’t Manage You – Part 2)

This is the final in a series on shrinking and transactions. You can see them all in the Shrinking & Transactions category. In part 1, we talked about factors that affect transaction log growth. We talked about what a SQL Server transaction is and the various modes SQL interacts with a transaction (Autocommit, Implicit Transactions and […]

Manage Your Transactions (So they don’t manage you – Part 1)

This is part 3 in a series on shrinking and transaction management. Click here for part 4. You can see them all in the Shrinking & Transactions category. If you are one of the people who have been reading this blog, you know where I stand on shrinking databases/log files. I don’t like the practice (Post 1, […]

Shrinking is a popular topic…

When I started blogging, my first posts were on shrinking. That’s still a popular search. Why?

Don’t Touch that Shrink Database Button!

Update [1-31-09] I wrote a follow-up to this regarding some of the questions that I see Google Search bringing folks to this blog. Check out my my additional post for some of the more common questions in the post, “Shrinking Databases is a Popular Topic“. Updated [11/16/13] This post continues to be a popular destination […]

Parse error: syntax error, unexpected 'Rights' (T_STRING) in /home2/mikew/public_html/straightpathsql.com/wp-content/themes/delegate-new/footer.php on line 22