That gave me a really good laugh first thing this morning. I think that's a pretty...

Ah, I didn't go back and look at the execution plan again.

Hey Jack,

Yeah, OPTIMIZE FOR is actually more than a little big dangerous. What happens when the underlying statistics change? You have to constantly review the work you did with it.

I...

WITH RECOMPILE was never a...

You can also use the OPTIMIZE FOR query hint as a way to force the plan down an optimal path.

Or Jack.

Or you for that matter.

I might though.

After migrating it's pretty strongly suggested that you update statistics with a full scan on all the tables in a database. Did you do this?

I think Barry's right. It's probably parameter sniffing.

Compare both execution plans. See what's different between the two.

Why do you need it to be in a single statement?

That's pretty cool. Gave me a laugh.

Just a suggestion on the original question, you might take a look at Red Gate's SQL Compare. It's not...

Monitoring stored procedures is best done by running what is called a server side trace. You can use the tool "Profiler" to define the trace and then script it out...

Keep hacking away at it, you'll arrive at something useful. In the mean time, you might want to pick up a book on database design. The one I like is...

motanihatim110 (1/4/2009)

---

Hi,

Thanks for reply.

It is not actually eConnect but modified version (smart connect which is eonesolution product and that is also modified by eonesolution for us). I dont know how...

rajg (1/5/2009)

---

About correcting IX_Path index, when I try to add two more columns it gives me warning. This index is created on TerritoryPath column which is varchar(900) field...So when I...

It sounds like you're taking the approach I would have expected based on all my readings on this topic. Logical and straight forward, playing against the strengths of each technology....