Paul White (@SQL_Kiwi) walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries involving computed columns.
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.
Aaron Bertrand (@AaronBertrand) kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.
Erin Stellato (@erinstellato) takes a look at the new COMPRESS and DECOMPRESS functions, comparing their impact on space and performance to traditional data compression.
