Tag : performance myths - SentryOne Team Blog

Tag: performance myths

Andy Mallon : Performance Myths : The query result cache

Andy Mallon : 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.

Derik Hammer : Myths : Table variables are always in-memory

Derik Hammer : Myths : Table variables are always in-memory

Guest author Derik Hammer (@SQLHammer) dismisses the common myth that table variables perform better than #temp tables because they are always in memory.