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.
