Forum Replies Created

Viewing 15 posts - 17,086 through 17,100 (of 22,214 total)

  • RE: Indexes with Include

    GilaMonster (6/26/2009)


    Grant Fritchey (6/26/2009)


    I wanted to be sure of the answer before I posted it, but it seems that SQL Server will most frequently pick the index with the most...

  • RE: What has been your experience of agile development

    David.Poole (6/26/2009)


    We have an experienced architect who has worked with agile development for a number of years.

    He has some pearls of wisdom

    1. It takes 18-24 months for the agile methodologies...

  • RE: Number of Reads in Profiler and Actual Execution Plan

    mike_walsh (6/26/2009)


    Did you ever solve this one? I am having a similar experience and it is puzzling enough that I might log a case with MS Support to better understand...

  • RE: BETWEEN In Join Condition

    Once you get the indexes in place, I'd suggest that a TOP with an ORDER BY is going to be more efficient in this situation than the MAX that you're...

  • RE: BETWEEN In Join Condition

    No. That wouldn't in and of itself make a triangular joind. Here's a great article by Jeff Moden[/url] that defines the triangular join better than I can.

  • RE: Indexes with Include

    I wanted to be sure of the answer before I posted it, but it seems that SQL Server will most frequently pick the index with the most columns. I tried...

  • RE: Sub-Query or Left-Outer Join (Performance Wise)

    Paul White (6/25/2009)


    That's ok Grant, but I'm not so sure, and I don't have the SQL source code to hand to check 😉

    A quick Google shows several books and articles...

  • RE: Are the posted questions getting worse?

    tosscrosby (6/26/2009)


    Steve Jones - Editor (6/26/2009)


    Alright, I'm leaving for a week. Behave yourselves on the thread.

    Please, please, please...put me in charge. I'll keep these heathens in check! 😀 We already...

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (6/26/2009)


    Ah, not yet. :hehe:

    Going to DC, dropping my son off at the National Youth Leadership Conference for a week, spending some time with my brother, speaking...

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (6/26/2009)


    Alright, I'm leaving for a week. Behave yourselves on the thread.

    Have a good time. I'll be going mid next week for a sojourn away from this...

  • RE: Are the posted questions getting worse?

    Alvin Ramard (6/25/2009)


    Grant Fritchey (6/25/2009)


    Hey, 2540F82F-05B8-4B01-A237-7A2A634E7D34. I was just talking about you with 0798AE98-F43B-4069-BE9F-5FFB9945D670. Good old 2540F82F, if you don't mind me being personal.

    Are you sure you weren't talking to...

  • RE: Are the posted questions getting worse?

    Florian Reischl (6/25/2009)


    Hey 5BAB5379-5B7D-4A79-A687-A6E8D4F5A444

    Old friend, sure you can call me 2540F82F! What's up with 0798AE98-F43B-4069-BE9F-5FFB9945D670?

    Grreets

    2540F82F-05B8-4B01-A237-7A2A634E7D34

    BTW: Since you choose my name, can I call you "papa-5BAB5379"?

    No.

  • RE: Responding to Email Received Through the Board

    I read them, but I don't want to send out my work email address if I don't have to (it's pretty much all over the place anyway, but I try).

  • RE: Are the posted questions getting worse?

    Florian Reischl (6/25/2009)


    GilaMonster (6/25/2009)


    There's a GilaMonster@gmail, a GilaMonster at DeviantArt[/url] and someone with GilaMonster as xbox gaming tag, that I know of. None are me. It's an uncommon nickname, but...

  • RE: Advantagess/Disadvantages of "INCLUDE" on Index

    I'd just add on to say, take it's advice with a rather large grain of salt, say about 12 inches square.

    It's very intrusive with it's suggestions and, if you test...

Viewing 15 posts - 17,086 through 17,100 (of 22,214 total)