GilaMonster (9/28/2011)

---

One index. Because SQL is not going to use three different structures and then have to patch them together unless it really has no other choice. It can do...

Heh, I was just looking at that!

This is part of my query:

FROM #EBuyers AS B

INNER JOIN #EVendors AS V

ON V.BuyerNumber = B.BuyerNumber

INNER JOIN tblProduct AS P WITH (NOLOCK)

ON P.VendorNumber =...

Awesome, thank you! It sounded logical, but I wanted to make sure I wasn't missing something.

Thank you very much!

Try physically working with quite a few knowledgable SQL people, using a 'not like' against a 650 million...

As far as FEELING goes, I'll give you...

I think the criticism is less "taking a blowtorch to his backside" and more commenting about how, for an article that clearly states its intended audience is "the junior database...