2005 Plan cache is pretty radically different than 2000.

Take a look at at this blog by some of the developers from MS. It might help.

Execution plans changed because of a recompile? That's a pretty likely possibility.

Take a look at the OUTPUT clause as a mechanism to capture the data that is inserted as it gets inserted. This is much more effecient, as well as easier...

If you want it to go into a temp table, this works fine (I used Adventureworks to test it):

SELECT ContactTypeID, [Name] INTO #mytem FROM Person.ContactType

union

SELECT StateProvinceID AS CultureID, [Name] FROM...

If you're getting multiple values from one table, you should probably apply some type of filter either in the ON statement of the join or in the WHERE clause. You...

After it gets applied, any impact is dependent on the number of rows inserted or updated against which an assertion for this constraint must be made. The more rows immediately...

Just that when you set up a linked server its available to every database and every user (that has the password, assuming you don't cache it in the connection, making...

Steve Jones - Editor (3/17/2008)

---

Speaking of lunch....

I once got a resume with the "Interests" section saying "Eating exotic meats"

I wanted to bring the guy in just to see him, but...

True. But based on what he had posted above I assumed he was already doing that much.

Not disagreeing, but I'd say the biggest tip would be to find some other method because they become a glaring security hole. But, if you absolutely, positively have to communicate...

Look up the topic "Linked Server" in the Books Online. That will get you started.

Try running Profiler over that same period of time. You'll see what exactly is getting called. Be sure you capture before & after the event in case a process runs...

You might wait a bit and see if anyone else posts anything else interesting here. You are working in an area where there is room for interpretation and others might...

Indianrock (3/17/2008)

---

Agile development has arrived at my company. If you research this topic you'll see a tendency to either try and work without a DBA, or require a new...

Yeah, that's a lively set of responses.

One thing that did come up over there that I should have raised, what are you using the schema's for? Is it to seperate...