Forum Replies Created

Viewing 15 posts - 44,206 through 44,220 (of 59,097 total)

  • RE: The T-SQL Paradigm

    Charles Kincaid (4/13/2009)

    Speaking of boards, one of the ones I kept hidden away was one that would dup a stack of cards and punch sequential numbers into the appropriate columns....

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

    April 13, 2009 at 12:03 pm

    #976784

  • RE: Are the posted questions getting worse?

    RBarryYoung (4/13/2009)

    Jeff Moden (4/13/2009)

    Heh... crud... I just sent Tony an email saying that I may have to cancel the book. Flo just beat the hell out of 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)

    April 13, 2009 at 11:51 am

    #976774

  • RE: TSQL help needed

    I can almost guarantee that there will always be 50,000 distinct SomeInts on the million row test. And, although the SomeLetters2 column is pretty random, the average number per...

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

    April 13, 2009 at 11:47 am

    #976767

  • RE: TSQL help needed

    GSquared (4/13/2009)

    Jeff, in your posted test harness, you need to rename the functions in the final tests. It has "SELECT SomeInt, dbo.ConcatTest...", but it needs to be Concat8kTest 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)

    April 13, 2009 at 11:44 am

    #976764

  • RE: TSQL help needed

    that's why I always include duration as a valuable test... it takes into account both CPU time and Disk Time. Of course, I list those, as well... good 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)

    April 13, 2009 at 11:42 am

    #976763

  • RE: Performance issue with tally solution

    Florian Reischl (4/13/2009)

    Jeff Moden (4/13/2009)

    I'm thinking that the hey-day of the Tally table have finally been replaced by faster methods.

    Don't say that. There might be actually two business cases where...

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

    April 13, 2009 at 11:09 am

    #976746

  • RE: The T-SQL Paradigm

    Aaron N. Cutshall (4/13/2009)

    Jeff Moden (4/13/2009)

    Heh... I'm just glad I'm not the only old fart on this site. My first "program" was on unit record equipment that used 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)

    April 13, 2009 at 7:36 am

    #976594

  • RE: Performance issue with tally solution

    aktikt (4/13/2009)

    Say it ain't so. This is the first I've heard a set based solution losing to RBAR.

    I don't have the desire to check right now, but what about using...

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

    April 13, 2009 at 7:31 am

    #976586

  • RE: How to make this stored procedure flexible?

    Thanks for the great feedback on this, Wayne. I wish more people felt like you about this type of thing. Too many folks just want code.

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

    April 13, 2009 at 7:25 am

    #976578

  • RE: Are the posted questions getting worse?

    RBarryYoung (4/13/2009)

    Jeff Moden (4/13/2009)

    Heh... crud... I just sent Tony an email saying that I may have to cancel the book. Flo just beat the hell out of 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)

    April 13, 2009 at 7:22 am

    #976572

  • RE: The T-SQL Paradigm

    andrew gothard (4/13/2009)

    Gift Peddie (4/11/2009)

    andrew gothard (4/11/2009)

    but I don't foresee the day when "one language to rule them all" will ever come into being. quote]

    Isn't that what ADA was...

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

    April 13, 2009 at 6:55 am

    #976531

  • RE: Performance issue with tally solution

    Florian Reischl (4/13/2009)

    I know Jeff will shoot me for this... 🙂

    @jeff

    The day to activate CLR on your servers is close 😀

    Heh... you may be right. Might also have 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)

    April 13, 2009 at 6:18 am

    #976496

  • RE: Are the posted questions getting worse?

    Heh... crud... I just sent Tony an email saying that I may have to cancel the book. Flo just beat the hell out of a Tally table split...

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

    April 13, 2009 at 1:05 am

    #976406

  • RE: Performance issue with tally solution

    Flo... there's a small error in your temporary stored procedure. It was leaving a leading space in the results. I've repaired it in the following but it still...

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

    April 13, 2009 at 12:43 am

    #976403

  • RE: Performance issue with tally solution

    Jeff Moden (4/12/2009)

    Florian Reischl (4/12/2009)

    Hello everybody!

    I have a performance issue with a set based solution. Please could you advice me what I'm doing wrong?

    ORDER BY on unindexed Tally table, for...

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

    April 13, 2009 at 12:08 am

    #976400

Viewing 15 posts - 44,206 through 44,220 (of 59,097 total)