Performance Myths : Truncate Can't Be Rolled Back 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. Guest Posts ◆ April 25, 2017 11
Performance Myths : Table variables are always in-memory Derik Hammer (@SQLHammer) dismisses the common myth that table variables perform better than #temp tables because they are always in memory. Guest Posts ◆ April 4, 2017 8