Tag : temp tables - SentryOne Team Blog

Tag: temp tables

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.

Paul Randal : Knee-Jerk Performance Tuning : Temp Tables

Paul Randal (@PaulRandal) continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary tables.