Transaction Log

SQLServerCentral Article

Dealing with Transaction Log Growth

  • Article

Introduction Relational databases are designed to track changes introduced to a database by data modification language (DML) commands. The fundamental reason for this construct is to ensure that changes are durable and that they can be rolled back reliably. The typical DML command used in SQL are INSERT, UPDATE and DELETE. When INSERT introduces new […]

(5)

You rated this post out of 5. Change rating

2022-06-13 (first published: )

6,805 reads

Blogs

What’s New at AWS re:Invent 2025 – Day 1 Highlights

By

Day 1 is an absolute thrill at re:Invent! I normally dedicate this dynamic day...

Running SQL Server on KubeVirt – Getting Started

By

With all the changes that have happened with VMware since the Broadcom acquisition I...

Why is shrinking IT budgets a good thing?

By

Each year around this time, companies enter the familiar ritual of budgeting. For many,...

Read the latest Blogs

Forums

Best analysis approach to reduce data type length in multiple tables

By Lord Slaagh

Hello SSC, I hope everyone is having a happy and safe holiday season! I...

Do you separate data/log files and TempDB files on different disks using AWS EC2

By WebTechie

Hello,   I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...

Service account being in local admin in AWS EC2 environment?

By WebTechie

Hello, I am working with a company on their database administration.  I am trying...

Visit the forum

Question of the Day

A New Operator

In SQL Server 2025, what does this code return?

SELECT '1' || '0'
 

See possible answers