http://blogs.sqlservercentral.com/ken_kaufman/default.aspxenCommunityServer 2007.1 (Build: 20917.1142)http://blogs.sqlservercentral.com/ken_kaufman/archive/2007/12/20/table-variables-temp-tables-recompilations.aspx#3373Wed, 16 Jan 2008 06:38:56 GMT70975365-724d-4ce8-8d1c-45c963ab81ff:3373Mike C<p>Hi Ken,</p> <p>Re: &quot;Variable tables are light in memory structures&quot;</p> <p>According to <a rel="nofollow" target="_new" href="http://support.microsoft.com/default.aspx/kb/305977">support.microsoft.com/.../305977</a>:</p> <p>&quot;Because a table variable might hold more data than can fit in memory, it has to have a place on disk to store data. Table variables are created in the tempdb database similar to temporary tables.&quot;</p> <img src="http://blogs.sqlservercentral.com/aggbug.aspx?PostID=3373" width="1" height="1">