I know I sound like a broken record sometimes, but have you looked at the execution plan to see which operations are specifically causing the most problem? That will lead...

Embarcadero ERStudio, but I wouldn't be swallowing when you see the price on that one either.

Great tool. Decent company.

Nothing to be sorry about. You'll just get quick responses because it's going to be seen by a wider audience.

You should start a new topic for this question.

Yeah, that is one the BIG weakness to the approach. You can't count on referential integrity. Basically we work from the model that there is an authoritative source for data....

Unless you want to tie the development schedules together (which is a perfectly viable option, but one that needs to be taken eyes open) you should seperate the databases. Once...

Oh, sorry, I am dense sometimes.

You have to open the Profiler trace file first. Then you can import the perfmon data.

I'd use the 4th option and turn on cascading deletes from there (if you really want to use those things). However, what happens if an address is used more than...

Just understand that you can't escape the 8060 limit by doing an insert and an update. If you exceed 8060 in a row, you've exceeded it.

Another option that you might...

If you haven't rebuilt the indexes on the this system in recent memory, I'd start there (and establish a mechanism that does it on a regular basis. There are several...

Not to push my own stuff, but I busted my bottom for Tony Davis to write the darn thing, so, try this article [/url]over on Simple-Talk as a starting point....

Which application are you referring to?

Just understand that, depending on the stored procedure in question, the performance increase will be miniscule or incredibly huge. The simplest of simple insert statements, for example, going to a...

Seperate the databases and provide a service (Service Oriented Architecture, SOA) that pulls the data from X in order to feed it to Y, through the applications, not through the...

I sure can't tell you. I white list your stuff about once or twice a month because it keeps getting flagged.