Use the output clause of insert.

Guy asks a question but wants a different answer than mine. Hopefully srength in numbers might save him months of work with absolutely no valid reason : http://www.sqlservercentral.com/Forums/Topic1174322-373-1.aspx

Actaully nope on all counts. The only difference is 1 prefix less in the queries and that's it. After a while you shouldn't even think about it, it...

Avalin (9/13/2011)

---

Not sure if I know how you mean, but...

This could also be a good candidate for table value parameter.

Well there's your problem.

FF 70 : I saw it too, but I assumed other figures had been tested. With DML anywhere in the table, I don't want to have FF 100% in...

All you save is dbo.archive vs dbname.dbo.archive?

You can use synonyms for that. The app upgrade would be far simpler.

That's called vmware & veem backups (or whatever your favorite vendor)!

How big are the dbs?

Making the history process is usually a big pita. I wouldn't destroy it if it works.

We still need to see the plans generated by all the queries that hit that table (at least the update). That way we can make better tuning.

Going under 2.5...

Usually first time only issue is with data cache.

Sp cache would have troubles all over the day.

You could schedule a job to warm up the cache or run the sp...

I'm guessing you're in a 24/7 shop with 0 maintenance window or something like that?

qur7 (9/13/2011)

---

Thanks, sorry i dodnt see the response, my bad.

i understand where you coming form but I have been asked to do so in a test enviroment.

i can make the...

Interesting.

How many rows in the table?

Can you post the an actual execution plan?

Can you post the indexes as well?

Any indexes on that table could be removed?