HomeNewsEventsBlogsForumsArticlesResourcesBiographiesSQL JobsAbout Us
Thursday, 9 September 2010
       
AUSQLUG Forums Home   Search   Login   Register   Member List  

  Viewing User Profile for: dgosbell
 About  Contact
Joined: 12 Oct 2004 11:28 AM
Last Login: 09 Sep 2010 01:54 AM
Website: http://geekswithblogs.net/darrengosbell/
Location: Unavailable to anonymous users.
Occupation: Unavailable to anonymous users.
Interests: Unavailable to anonymous users.
Signature:
Email: Unavailable to anonymous users.
MSN IM: Unavailable to anonymous users.
AIM: Unavailable to anonymous users.
Yahoo IM: Unavailable to anonymous users.
ICQ: Unavailable to anonymous users.
 Post Statistics
dgosbell has contributed to 3 out of 1,566 total posts (0.19% of total).
Most Recent Posts:
MDX Jumpstart - Darren Gosbell 17/07/2007 1:24:25 PM   (Total replies: 0)
Slides and MDX Scripts from Darren Gosbell's MDX Jumpstart presentation

Re: Should table variables be changed to work IN-MEMORY exclusively? 21/02/2006 3:14:04 PM   (Total replies: 1)
I like Jeremy's idea. Initially I used to favour table variables over temp tables in certain circumstances because their name lead me to believe that they were only a memory structure. And when I was under this incorrect assumption I used to target my usage so that any large temporary structures I put in #temp tables and smaller ones I put in @temp tables. I think the main problem here is one of perception. If MS had called them "temp table pointers" or "temp table mapped variables" then ...

Re: Should table variables be changed to work IN-MEMORY exclusively? 8/03/2006 10:34:53 AM   (Total replies: 1)
The following is an excerpt from the sql-server-performance.com newsletter which I recieved today. Which from the discussion on this thread is just plain wrong, but explains some of how the incorrect perceptions have been propogated. <-- SNIP --> If you need a temporary table in your Transact-SQL code, consider using a table variable instead of creating a conventional temporary table instead. Table variables are created and manipulated in memory instead of the tempdb database, making them ...

Search for more...