Forum Replies Created

Viewing 15 posts - 43,021 through 43,035 (of 59,098 total)

  • RE: What SQL Server Sites do you use?

    Steve Jones - Editor (7/15/2009)

    That's one of the things I've been concerned about, as I agree with Jeff on Barry's posts.

    I wouldn't mind seeing some "voting" to help people decide...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 15, 2009 at 11:55 am

    #1025258

  • RE: Help us tune a query

    Heh... correction! It looks like the updates may be on a timer... both new posts suddenly registered on the home page. Still, I wouldn't spend much more time...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 15, 2009 at 8:51 am

    #1025118

  • RE: Help us tune a query

    Heh... well, that little test pretty much cinches things up. The addition of the post above didn't change my counts on the home page what-so-ever.... not even in a...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 15, 2009 at 8:48 am

    #1025115

  • RE: Help us tune a query

    Just a test... please ignore this post.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 15, 2009 at 8:40 am

    #1025103

  • RE: Help us tune a query

    Mel Harbour (7/15/2009)

    It's just below the table definition. Scroll down the code block a couple of posts above and you should see them.

    Heh... thanks Mel... you're reading my mind and...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 15, 2009 at 7:09 am

    #1025002

  • RE: Help us tune a query

    Mel Harbour (7/15/2009)

    I don't understand the logic behind its selection of IX_UsersDisplayName when it does the join into the Users table. Perhaps I'm just totally misunderstanding how indexes work, but...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 15, 2009 at 6:54 am

    #1024988

  • RE: Help us tune a query

    GilaMonster (7/15/2009)

    Jeff Moden (7/14/2009)

    Something else is going on as well. Look at the difference in durations on your machine compared to mine.

    Look at the difference in reads...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 15, 2009 at 6:47 am

    #1024981

  • RE: Help us tune a query

    Mel Harbour (7/15/2009)

    You should just be able to right-click and save as for the sqlplan. I'll attach a zipped version to this post as well, just to be on the...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 15, 2009 at 6:42 am

    #1024973

  • RE: Help us tune a query

    Mel Harbour (7/15/2009)

    You should just be able to right-click and save as for the sqlplan. I'll attach a zipped version to this post as well, just to be on the...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 15, 2009 at 6:38 am

    #1024970

  • RE: What SQL Server Sites do you use?

    RBarryYoung (6/17/2009)

    As long as I'm making lists, What, IMHO, did/does Not work:

    A) "Accepted" or "Answer" flags: It seems like such a good and obvious thing: flag which one is...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 15, 2009 at 6:23 am

    #1024955

  • RE: Help us tune a query

    Jeff Moden (7/15/2009)

    Mel Harbour (7/15/2009)

    Ok, I've run a modified version of Jeff's suggestion:

    Something sure is wrong... look at the difference between the CPU and the duration compared to my box.

    Something...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 15, 2009 at 6:14 am

    #1024949

  • RE: Help us tune a query

    Also, here's what the new zipless sqlplan does in IE...

    The XML page cannot be displayed

    Cannot view XML input using style sheet. Please correct the error and then click the...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 15, 2009 at 6:11 am

    #1024947

  • RE: Help us tune a query

    Mel Harbour (7/15/2009)

    Ok, I've run a modified version of Jeff's suggestion:

    Something sure is wrong... look at the difference between the CPU and the duration compared to my box.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 15, 2009 at 6:02 am

    #1024941

  • RE: Help us tune a query

    Okidoki... thought I'd throw my hat into the ring on this, as well. I didn't try G-Squared's code yet, but here's mine.

    First, the test harness. It create a...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 15, 2009 at 1:01 am

    #1024834

  • RE: Help us tune a query

    I think I found out how many... would it be right around 106,916?

    The only thing I need to know now is how many users are in the Users table? ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    July 14, 2009 at 11:01 pm

    #1024810

Viewing 15 posts - 43,021 through 43,035 (of 59,098 total)