For this month's T-SQL Tuesday, Aaron Bertrand shows that when triggers are necessary, in some cases INSTEAD OF triggers can be better for performance than AFTER triggers.
Derik Hammer (@SQLHammer) sets out to disprove another pervasive performance myth : TRUNCATE is faster than DELETE because it isn't logged and can't be rolled back.
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 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.
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.
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.
Aaron Bertrand (@AaronBertrand) discusses ways to optimize large delete operations, both to make them faster, and to minimize impact on the transaction log.
