Great to hear your issue has been solved.

Looking forward to the blog post.

Johan

Please no cursors in The Thread :hehe:

I've seen that too.

That's why I script all my restores and alter the names myself.

You can also do that in the GUI.

rellirel82 (3/15/2011)

---

I can't give you an answer to your question but I also has something similar to you. It errors out at my Insert Into statement. I believe...

Indeed. Dropping a single plan can only be done as of SQL2008.

have a look at http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/11/22/virtualizing-sql-on-vmware-reference-list.aspx

Select ABS("The is no such thing as a game!") as Game_is_War

--results--

Game_is_War

-------------------------------------------

Let's have some fun. See what we can learn.

If I'm correct you intended to opdate the temp table ?

You should modify the code Lowell provided to update the correct target !

(his query updates the data in the A...

Can you post both execution plans ? (show actual execution plan and save the .sqlplan)

Anyway you should set it if you don't want a single query eating up all your cpu capacity. ( a risk when leaving it at the default 0 )

Keep in mind, doing...

If you would have posted both execution plans, we would get a better picture of what might be going on.

My guess, your select for id based on a (non indexed)...

I use tweetdeck for Chrome.

I recently noticed it shows the "conversation" of a tweet if you click to reply to it :w00t:

Still twitter is a forest with many birds.

Hard...

Best is to create your temp table and then perform a regular insert into #temptb select .... yourunionquery

Indianrock (3/14/2011)

---

I actually watched that webcast last week. I don't want to resurrect the whole debate about ORM vs. stored procedures. The fact is that many IT shops...