Forum Replies Created

Viewing 15 posts - 43,801 through 43,815 (of 59,063 total)

  • RE: Performance issue with tally solution

    Heh... oh my... :hehe: I believe I've found the secret as to why Cross Apply makes the Tally table solutions run so fast. It forces an unnatural ORDER...

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

    May 9, 2009 at 10:26 pm

    #991715

  • RE: Performance issue with tally solution

    Peter,

    Sorry man. I tested against 1000 lines of 800 comma separated random numbers each in a VARCHAR(8000) environment... your code did the split into a table at a minute...

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

    May 9, 2009 at 10:16 pm

    #991714

  • RE: Performance issue with tally solution

    Phil Factor (5/1/2009)

    Jeff,

    ...but their developers seem unable to fix things so they work like they used to.

    Ouch.

    They're doing all they can to put in a better solution ASAP. The problem...

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

    May 9, 2009 at 9:31 pm

    #991711

  • RE: Performance issue with tally solution

    Peter,

    How do I determine what the optimal sector size in your splitter code should be?

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

    May 9, 2009 at 8:32 pm

    #991709

  • RE: Performance issue with tally solution

    Sorry, Peter... I got it. You were talking about the code in the previous 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)

    May 9, 2009 at 8:06 pm

    #991704

  • RE: Performance issue with tally solution

    peter (5/5/2009)

    Thanks for the information Jeff...care to take a quick look at what your string splitter evolved into as well?

    Sorry Peter... I'm out of coffee and I'm not sure of...

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

    May 9, 2009 at 7:57 pm

    #991700

  • RE: Matrix multiplication without cursors?

    Sorry, Phil... the proc you attached came out as one huge line. I won't even start to look at something like that.

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

    May 9, 2009 at 7:44 pm

    #991697

  • RE: SET vs SELECT

    The artical that Paul White pointed us to about the peformance difference between SELECT and SET is pretty close to spot on percentage wise. I'm just not one to...

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

    May 9, 2009 at 7:30 pm

    #991695

  • RE: "tempdb" size -- 550GB!

    Barkingdog (5/9/2009)

    More info:

    1. Temp 550GB was not enough. t-sql job ran into 550GB limit and failed.

    2. Found statement causing the issue. The essence is shown below:

    insert into

    ..

    select distinct ....

    ....

    from

    tableA join...

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

    May 9, 2009 at 6:22 pm

    #991693

  • RE: SET vs SELECT

    Wow... that's a heck of a table. I am so not jealous of either that or the rigors they seem to be putting you through.

    Thanks for 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)

    May 9, 2009 at 9:55 am

    #991641

  • RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

    Manie Verster (5/9/2009)

    You only put A-Z and not also a-z. How does that work?

    Peter gave a pretty good description as to why. To simplify, the default for SQL Server...

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

    May 9, 2009 at 9:23 am

    #991630

  • RE: SET vs SELECT

    Florian Reischl (5/9/2009)

    Jeff Moden (5/9/2009)

    BTW - It is good to see growing acceptance of the idea that ANSI standards are kinda 'blah'. I couldn't agree more 🙂

    Man, I agree...

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

    May 9, 2009 at 8:52 am

    #991625

  • RE: SET vs SELECT

    John Esraelo (5/9/2009)

    have not we have had kicked this dead horse plenty..

    I think we did..

    :))

    The bones of these types of dead animals are interesting... its especially interesting to see how...

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

    May 9, 2009 at 7:57 am

    #991621

  • RE: SET vs SELECT

    Paul White (5/9/2009)

    Jeff Moden (5/8/2009)

    Paul White (5/8/2009)

    When assigning multiple variables from constants, SELECT is significantly quicker than separate SET statements.

    Heh... I agree, but where's the code to prove that? ...

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

    May 9, 2009 at 7:53 am

    #991620

  • RE: SET vs SELECT

    Paul White (5/8/2009)

    John,

    When assigning multiple variables from constants, SELECT is significantly quicker than separate SET statements.

    Just adding that for completeness.

    Paul

    Heh... I agree, but where's the code to prove that? ...

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

    May 8, 2009 at 8:00 pm

    #991547

Viewing 15 posts - 43,801 through 43,815 (of 59,063 total)