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
It’s not you, it’s me (I/O troubleshooting) Monica Rathbun (@SQLEspresso) talks about a few of the more common elements she always checks for when troubleshooting I/O problems. Guest Posts ◆ April 18, 2017 6
Cardinality Estimation for a Predicate on a COUNT Expression Paul White (@SQL_Kiwi) takes you on an optimizer journey, exploring how SQL Server comes up with cardinality estimates for COUNT queries. Paul White ◆ April 12, 2017 5
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
