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

I like the article. Showing common cursor practices and a nice set-based approach to replace them is absolutely the right way to go. Unfortunately, as Jeff already pointed out, you...

Manie Verster (1/2/2009)

---

Sounds like a good idea. I just think that...

I was just reading a blog post by Hugo Kornelis. He said, based on his tests, STATIC was the way to go, that it outperformed FASTFORWARD cursors.