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....

Jeff Moden (1/2/2009)

---

Grant Fritchey (1/2/2009)

---

Absolutely. One of the biggest problems we have where I work, an ANCIENT insurance company, is the entrenched knowledge, "We've always done it this way," even...

JoeA (1/2/2009)

---

Hi Grant - I just came across this discussion and was wondering how your project is going.

I'm on a team that is reengineering a very large application...

Jack Corbett (1/2/2009)

---

I also have to agree with Grant, but in my experience you will rarely be joining enough tables where the order will be important. Also, in my...

I just repeated your tests and did not get your results.

Just a guess, did you highlight it exactly the same way both times? Meaning, including carriage return and line feeds...

I may as well be the dissenting opinion.

It depends on the complexity of the joins. When we're talking about simple, say fewer than 15 or so, tables joined together,...

There is less disparity between the estimated & the actual, so that's good. You've still got a missing JOIN predicate. That should get fixed.

I still suggest you run UPDATE STATISTICS...

Maybe a change to the connection settings? This will cause a new plan to be compiled.

At least show what you've tried that hasn't worked.

AndyG (1/2/2009)

---

Exactly - at the companies I have worked at, we often have *more* problems with the people that do have industry experience because no two companies do anything the...

wagner crivelini (1/2/2009)

---

Well, I understand the fuzz, although I didn't mean to create it.

When I wrote this article I had in mind that not all T-SQL beginner are completely unaware...

It has to be a "nice to have." Most of the time, your statement of "data is data is data" is just too true. My experience has been reasonably wide...

First things first, do you have automatic statistics enabled on the database? If not, why not?

The index IX_VarOffice is showing as 1 estimated row and 84,000 actual rows. That's usually...