Matt Miller (4/16/2008)

---

Quick ruling here - do middle managers who couldn't cut it as data trolls, and who now issue dictates as to how things should be implemented count as...

Very nicely done, Ian! Congratulations!

Steve F. (4/18/2008)

---

Hello,

I have a table with over 10 million rows. Each row has one of 8 dates attached to it, roughly evenly distributed across the 8 days. ...

As you probably already know (just making sure), CTE's are nothing more than another way of creating a derived table except you do it up front instead of in the...

Jim Russell (4/18/2008)

---

That's the chauvinistic IT department high priest answer!

I don't care about the job title of the author of the problematic query, I just want to limit the impact.

(And...

Would you mind posting your...

Thanks folks. I really appreciate the feedback especially on a long one like that.

I like the numbers table based solution better, too! It eliminates the loop, runs faster because it uses a single insert, and is a bit easier on the eyes.

See...

Sorry folks... dunno how I missed this one.

Antonio... I sure do appreciate the attention to detail you put into the tests you did and the reports that followed. Absolutely...

Glad you posted this... Cheddar late than never... 😀

Ya gotta be "stumped" to practice those...:hehe:

Keep in mind what I said in the conclusion of the article on triangular joins...

Not all Triangular Joins are bad. With some restraint and the right criteria, Triangular Joins can...

escaleraroyal (4/17/2008)

---

Jeff Moden (4/16/2008)

---

escaleraroyal (4/16/2008)

---

update.

Vendor says the same applicationX runs fast in another company1 which has a higher volumne of data. He thinks it's our clustering server that is causing...

jburkman (4/17/2008)

---

Jeff Moden (4/17/2008)

---

Jeff Moden (4/17/2008)

---

It's a tail yank, Brandie... someone who hates East Indians and is trying to give them a bad name. It would appear that was...

Jeff Moden (4/17/2008)

---

It's a tail yank, Brandie... someone who hates East Indians and is trying to give them a bad name. It would appear that was the whole intent...