Friday, 9 July 2010

Temporary Tables vs. Table Variables

  Temp Table Table Variable
record transaction logs? Yes No
inside transaction scope? Yes No
cross execution batch? Global temp table No way
support index? Yes No
where to store? Tempdb Memory

No comments: