Post reply

@tablename vs #tablename

  • July 21, 2005 at 9:34 am

    #66465

    Can someone explain the difference between using @myTable Table

    and #myTable and why would I choose one over the other

  • July 21, 2005 at 9:36 am

    #576127

    Here you go:

     


    * Noel

  • July 21, 2005 at 9:39 am

    #576128

    Nevermind

     

  • July 21, 2005 at 2:21 pm

    #576235

    ok Ray - now I see where you got your black eye - good thing Remi's on vacation - else it might've been 2 (black eyes ie)..

    btw - you are not Ray Martinez revisiting the site as Ray M are you ?!?! curious because both your styles (t-sql) are so similar...







    **ASCII stupid question, get a stupid ANSI !!!**

  • July 21, 2005 at 2:51 pm

    #576243

    well, black eye ... sounds too painful

    and if I have to guess I would say is the SAME person

     


    * Noel

  • July 21, 2005 at 11:46 pm

    #576303

    Yeah, one and the same.

    Just shortened my name to protect the innocent.

    I didn't realize I had any style.

    Just dreaming of the day when I get to 500 Posts.

  • July 22, 2005 at 5:57 am

    #576372

    An additional problem with table variables that I found in practice is that the query processor cannot make use of a parallel query plan with table variables. A procedure ran in under a second on a development server (single processor) but took minutes in production (multi-processor). Simply replacing the table variables with temporary tables fixed it.

  • July 22, 2005 at 9:42 am

    #576478

    Inherently sql server handle's memory very well, but the in memory temp tables have some sort of bottleneck. When there are a ton of rows 100's vs 10,000s, Then the use or query of the in memory table becomes very sluggish, it has to do with a bunch of memory swapping it has to do.

    Temporary objects can be avoided in some circumstances and I try to use them sparingly.

    my $0.10, $0.02 is Free

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply