Re: Temp tables vs. Table variables

From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 09/28/04 

Date: Tue, 28 Sep 2004 10:30:17 -0400

"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:%23rJCpaWpEHA.348@TK2MSFTNGP15.phx.gbl...
> > considering thetable variable does not
> > have to write to tempdb and is kept in RAM?
>
> Who said that was the case?

    I've read that misconception in lots of articles, unfortunately, e.g.:
http://www.eggheadcafe.com/articles/20010823.asp

    "... using the new SQL Server TABLE type. This is more or less a "clone"
of an actual table, except that it is a variable and it normally operates
100% IN MEMORY ..."

    It's unfortunate that a lot of websites don't have articles tech
reviewed (never mind copyedited) before publishing them and creating
confusion.

Relevant Pages

  • Re: Temp tables vs. Table variables
    ... "Tammy Moisan" wrote in message ... Do you think that with such a small record set these two would> more than double the response, considering thetable variable does not> have to write to tempdb and is kept in RAM? ...
    (microsoft.public.sqlserver.programming)
  • Re: Apple and 64 bit apps - the latest in this series
    ... I see no evidence that any users are "confused". ... the OEM picks the right Windows for that hardware. ... If you have not seen evidence of confusion, ... RAM he can afford, and could end up with a 64-bit machine he can't migrate ...
    (comp.sys.mac.advocacy)
  • [HPADM] Re: Looking for HP-UX 10.20 media
    ... I must have had a confused moment--the workstation I have is a 735, ... Specifically, it is a 735/99, and has about 200 MB RAM. ... I apologize for the confusion. ... To subscribe/unsubscribe to this list, ...
    (HP-UX-Admin)
  • STMicroelectronics Introduces ARM9 Microcontroler with 2.1 Mbytes Flash
    ... Kbytes of RAM: ... Embedded Ethernet, ... publishing the backlog, future articles will be published in a "more timely" manner. ... additional features will become noticeable in future news articles. ...
    (comp.arch.embedded)
  • Re: SQL server 6.5 unable to start
    ... Start the SQL server in Minimal mode ... sp_configure 'tempdb in ram ',20 ... > default database device. ...
    (microsoft.public.sqlserver.server)