Transaction Log Archives - SQLPerformance.com

T-SQL Tuesday #65 : Teach Something New

Posted by Aaron Bertrand on April 14, 2015 1 Response »

Apr 142015

For T-SQL Tuesday, Aaron Bertrand (@AaronBertrand) gives a little detail on something he learned this week about altering a column from NOT NULL to NULL.

Delayed Durability in SQL Server 2014

Posted by Aaron Bertrand on April 28, 2014 13 Responses »

Apr 282014

Aaron Bertrand (@AaronBertrand) describes the new SQL Server 2014 feature, Delayed Durability, and puts it through its paces.

Making the Case for INSTEAD OF Triggers – Part 1

Posted by Aaron Bertrand on March 25, 2014 No Responses »

Mar 252014

SQL Sentry's Aaron Bertrand (@AaronBertrand) does some deeper testing on triggers, showing that INSTEAD OF triggers are worth a look.

Transaction Log Monitoring

Posted by Paul Randal on November 21, 2013 3 Responses »

Nov 212013

Paul Randal (@PaulRandal), CEO and owner of SQLskills.com, discusses monitoring the transaction log, as he rounds out his series on transaction log configuration and management.

SQL Server 2014 : Native backup encryption

Posted by Aaron Bertrand on October 16, 2013 7 Responses »

Oct 162013

SQL Sentry's Aaron Bertrand (@AaronBertrand) takes a quick look at performance of encrypted backups in SQL Server 2014, and points out a couple of other things you'll want to know before implementing the feature.

The Myth that DROP and TRUNCATE TABLE are Non-Logged

Posted by Paul Randal on May 31, 2013 9 Responses »

May 312013

Paul Randal (@PaulRandal) of SQLskills.com discusses the myth that DROP and TRUNCATE operations are not logged, and shows that this is simply not true.

Looking at Database Snapshot Performance

Posted by Jonathan Kehayias on May 21, 2013 9 Responses »

May 212013

Jonathan Kehayias (@SQLPoolBoy) of SQLskills.com takes a look at snapshot performance, with some surprising observations about what happens if you have more than one concurrent snapshot.

1 2