Estimated Execution Plan Temp Table

-
Estimated Execution Plan on Temp Table
Estimated Execution Plan with #TempTable
Estimated Execution Plan MS SQL Server

Recently I encountered a problem while trying to understand the performance issues with one of my stored procedures in SQL Server 2008.

This specific stored procedure uses a #tempTable to store some data. It looks like this:
Obviously I encountered "Invalid object name '#TempTable'."
I saw some places online which suggested several things, but the best solution for this was the simplest.

1. Simply comment the "drop table #tempTable" you do at the end of the stored procedure.
2. Run the query (which will save the #tempTable).
3. Click on the Estimated Execution Plan button.

Since you have data in your #tempTable, you can run it freely.

p.s.
Don't forget to drop this table when you're done.

Hope it helped,
Elad Shalom,
CTO at ITweetLive.com

Comments

  1. RippoMarch 15, 2012 at 12:40 PM

    or use a table variable and forget the #tmp table altogether declare @tmp table (id int, etc)

    ReplyDelete
    Replies
    1. AnonymousMarch 27, 2012 at 5:24 PM

      Yet sometime you can't avoid #tmp. If you inherited a stored procedure or have some awkward select with a long list of columns and a short amount of time.

      I agree variable tables are usually(!) better, but you sometimes have to find fixes and workarounds to deal with what you get.

      In this specific problem I had 0 time to find out what's wrong and I couldn't cought it with profiler/ sp_whosactive.

      Thanks for the comment though :)

      Delete
  2. RippoMarch 15, 2012 at 12:40 PM

    This comment has been removed by the author.

    ReplyDelete
  3. AnonymousAugust 8, 2014 at 12:01 AM

    nike free, louis vuitton outlet online, chanel handbags, oakley sunglasses, burberry outlet online, air max, tiffany and co, ray ban, prada outlet, ray ban sunglasses, burberry outlet online, louboutin, longchamp outlet, louboutin, coach outlet store, polo ralph lauren outlet, oakley sunglasses, jordan shoes, oakley sunglasses, coach factory outlet, coach outlet, nike shoes, michael kors outlet, gucci outlet, coach purses, coach factory, tory burch outlet, prada handbags, oakley sunglasses, toms shoes, louis vuitton handbags, true religion jeans, true religion outlet, kate spade outlet, ray ban sunglasses, true religion, polo ralph lauren, nike air max, oakley sunglasses, michael kors outlet

    ReplyDelete
  4. UnknownJuly 22, 2016 at 1:23 PM

    jordan shoes
    rolex replica watches
    fitflops sale clearance
    canada goose sale
    christian louboutin uk
    canada goose uk
    louis vuitton purse
    reebok outlet store
    lacoste shoes
    north face jackets
    nike air max 90
    coach outlet online
    air jordan shoes
    ray ban sunglasses outlet
    longchamp bag
    ugg boots
    instyler max
    true religion jeans outlet
    oakley sunglasses outlet
    louis vuitton handbags
    canada goose sale
    moncler uk
    coach outlet online
    cheap ray bans
    michael kors handbags
    dolce and gabbana outlet online
    jordan pas cher
    longchamp outlet store
    babyliss hair dryer
    nike store uk
    ecco outlet
    kate spade bags
    polo ralph lauren
    cheap ray ban sunglasses
    20160722caiyan

    ReplyDelete
  5. caiyanOctober 21, 2016 at 11:34 AM

    coach outlet
    nmd adidas
    adidas yeezy
    coach factory outlet
    ugg boots
    raybans
    michael kors outlet
    ugg outlet
    rolex daytona
    cheap oakleys
    20161021caiyan

    ReplyDelete
  6. UnknownMarch 14, 2017 at 11:04 PM

    cheap jordans
    adidas nmd
    christian louboutin heels
    oakley sunglasses
    louboutin outlet
    christian louboutin sneakers
    michael kors outlet online
    mizuno sneakers
    toms outlet
    adidas yeezy 350 boost
    2017.3.15chenlixiang

    ReplyDelete
  7. BensonJuly 15, 2019 at 12:31 AM

    fitflops sale clearance
    ferragamo belt
    bape hoodie
    hermes outlet online
    cheap jordans
    chrome hearts online
    coach outlet online
    kobe shoes
    michael kors
    off white jordan 1

    ReplyDelete
  8. yanmaneeeJanuary 20, 2020 at 12:26 AM

    supreme clothing
    kobe sneakers
    nike shox
    fitflops sale clearance
    supreme outlet
    fila
    yeezy shoes
    balenciaga
    goyard
    adidas stan smith shoes

    ReplyDelete
  9. yanmaneeeMarch 21, 2020 at 1:28 AM

    golden goose outlet
    goyard
    goyard bags
    golden goose shoes
    golden goose outlet
    goyard handbags
    yeezy shoes
    moncler outlet
    golden goose sneakers
    golden goose

    ReplyDelete

Post a Comment

Popular posts from this blog

Linked Files in Visual Studio 2010

-
Image
File Linking, File Sharing and Shared Projects. You know how it feels to have shared files on VSS? Gooood . Actually it felt so good that my beloved CTO (who said something about promotion?) switched to TFS just 4-5 months ago.  And ever since - I cry myself to sleep every night. Instead of one file, shared between 5,6,7 or 10 projects, we now have a copied file for each project.  This is due to Microsoft "Best Practice" which says - No Shared Files . Meaning...? If I have a JavaScript file called Arrays.js.  It's all purpose is to handle arrays in JavaScript.  This file exists in 6 different projects, which mean, that if I have another addition to this small JavaScript library, I have to copy it to 6 different files in 6 different projects... JUST SHOOT ME!!! Finally, I have the fix we've all been waiting for, courtesy of VS 2010: "Add File As Link" How to Link Files to Different Projects: Let’s say we have 2 completely dif
Read more

Protecting Personal Data

-
Protecting personal data can be overwhelming, but it is not impossible. There are highly secure tools both online and offline to protect personal data. Shielding personal data can be logical, highly secure as well as inexpensive. Protecting Personal Data Offline   Physically lock your financial records and personal documents in a safe place in your home. Purchase an inexpensive fire-proof safe that can be stored in a secure closet, built in your floor or wall.   A good fireproof safe costs from $100 to $3000 (Sears, 2013). Protect your wallet and or purse in a desk drawer at work. Limit what you carry when you go out. Never keep your social security card in your wallet; lock it up. When filling out forms in the workplace, the doctor’s office, or your child’s school ask how your information will be safeguarded. If you do not have to fill out every little detail of your life, leave that portion blank. Ask for the consequences of not providing specific information. Shr
Read more

SEO One On One - Web of Links

-
Creating Links, Connecting other sites to yours. The term Web of Links refers to creating multiple sites, each connected to the other one, in order to promote a specific website. This is exactly what a website owner would like, an hour work (and about 50$  investment) which will generate his website 25 links. Web of Links is mainly for indexing purposes and less for getting a higher page rank (PR) in search engines (Google). I'll start by explaining the benefits of the Web of Links method: Let's say you just created a website. You've made all the right things... Listed your site in all the indexes websites, registered to Google Analytics and Google Web Master Tool and even wrote some content pages in order to attract visitors. This is good, the only problem is that Google may have not indexed all you pages yet.  If you're a small new website, this process can take awhile. The Web of Links idea simply makes the linking process smoother. Enter a domain s
Read more