Tag : performance myths - SentryOne Team Blog

Tag: performance myths

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.