Transaction Log Archives - Page 12 of 12 - SQL Authority with Pinal Dave

Envelopes dropping through a letter slot into a large basket

Designing Tables for High Insert Rates

September 17, 2007

Clustered Index, SQL Index, SQL Server, Table Partitioning, Transaction Log

High insert rates depend on key choice, row width, index count, and retention design; learn a practical SQL Server table layout for sustained writes.

A barrel marked LOG overflowing with paper, and a person hesitating at the tap.

SQL SERVER – Shrinking Truncate Log File – Log Full

December 30, 2006

Pinal Dave

SQL Performance

SQL Backup and Restore, SQL Scripts, Transaction Log

The old code I used to truncate log file space with DBCC SHRINKFILE and BACKUP LOG WITH TRUNCATE_ONLY. It breaks the log chain, so take a full backup after.