Performance Myths: The query result cache Andy Mallon dispels the myth that SQL Server maintains some kind of query result cache to make future executions of the same query faster. Guest Posts ◆ July 23, 2018 1
Performance Myths : Oversizing string columns Aaron Bertrand (@AaronBertrand) shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns. Aaron Bertrand ◆ June 14, 2017 21
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
