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...

FYI - Maybe you can find some help and advise in this "Advantages to Using Stored Procedures over ORM Tools" by Idera.

Yesterday I encountered a nice list that will be a very good starting point:

http://blogs.msdn.com/b/cindygross/archive/2011/03/10/general-hardware-os-network-guidelines-for-a-sql-box.aspx

You have a great tool set at your disposal.

If you also have their query optimizer, your biggest challange will only be the collaborative model.