Posted by Helmut Woess on 01/26/07 16:28

Am 26 Jan 2007 05:43:42 -0800 schrieb Burbletrack:

> Hi All,
>
> Hope someone can help me...
>
> Im trying to highlight the advantages of using table variables as
> apposed to temp tables within single scope.
> My manager seems to believe that table variables are not advantageous
> because they reside in memory.
> He also seems to believe that temp tables do not use memory...
>
> Does anyone know how SQL server could read data from a temp table
> without passing the data contained therein through memory???
>
> Is this a valid advantage/disadvantage of table variables VS temp
> tables?

Maybe this can help you a little bit:
http://support.microsoft.com/kb/305977/EN-US/

bye,
Helmut

• Next in forum: Re: Input Paramter as part of OPENDATASOURCE
• Prev in forum: Re: Paging records on SQL 2000 : Followup question
• Thread view: Re: The age old argument of Temp table vs Table variable

[Reply to this message]