Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: One index, or three?

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

  • RE: One index, or three?

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

  • RE: One index, or three?

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

    Thank you very much!

  • RE: Understanding Indexes

    Peter Trast (2/15/2011)Sometimes I am even nervous about participating in the dialog 🙂

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

  • RE: Understanding Indexes

    Charles Kincaid (2/15/2011)Still the "blowtorch to the backside" was about the cleanest way that I could think of to state how this feels.

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

  • RE: Understanding Indexes

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

Viewing 6 posts - 1 through 6 (of 6 total)