Hey Sandy,

Sorry I'm late to the game, but everything Jeff said goes double for me. 😀

The two things I saw that stood out was that there was a join without a predicate. That's usually not a good thing. Joins, for the most part, should have...

Looks good. Thanks.

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?