Shrinking & Transactions

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 … Read more

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, … Read more

Don’t Touch that Shrink Database Button In SQL Server!

[et_pb_section bb_built=”1″ admin_label=”Section” fullwidth=”on” specialty=”off” transparent_background=”off” background_color=”#ffffff” allow_player_pause=”off” inner_shadow=”off” parallax=”off” parallax_method=”off” padding_mobile=”off” make_fullwidth=”off” use_custom_width=”off” width_unit=”on” make_equal=”off” use_custom_gutter=”off” global_module=”2469″][et_pb_fullwidth_post_title admin_label=”Post Title” global_parent=”2469″ title=”on” meta=”on” author=”on” date=”on” categories=”on” comments=”on” featured_image=”off” featured_placement=”below” parallax_effect=”on” parallax_method=”on” text_orientation=”left” text_color=”dark” text_background=”off” text_bg_color=”rgba(255,255,255,0.9)” module_bg_color=”#152f3e” use_border_color=”off” border_color=”#ffffff” border_style=”solid” title_font=”|on|||” title_text_color=”#ffffff” meta_text_color=”#eeeeee” /][/et_pb_section][et_pb_section bb_built=”1″ admin_label=”Section” fullwidth=”off” specialty=”on”][et_pb_column type=”2_3″ specialty_columns=”2″][et_pb_row_inner admin_label=”Row”][et_pb_column_inner type=”4_4″ saved_specialty_column_type=”2_3″][et_pb_image admin_label=”Featured Image (700×394)” … Read more