Forum Replies Created

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

  • RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

    Jeffrey Williams (4/13/2009)

    Here is a previous discussion that shows how to do multiple aggregations in a single pivot. We went back and forth on the various forms of pivot/cross-tab...

    --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:15 pm

    #976981

  • RE: The T-SQL Paradigm

    Heh.... then there were the new Mylar cuts and the "angel dust" the punches made. Nasty.

    Anybody remember the old Remington punch cards?

    --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:08 pm

    #976980

  • RE: Are the posted questions getting worse?

    GSquared (4/13/2009)

    CLR does a faster running total than the quirky update too.

    As we've known for quite some time, SQL just plain isn't good at what it isn't designed 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:20 pm

    #976800

  • RE: Use of GO

    Abhijit More (4/13/2009)

    Vijaya,

    I must appreciate for explanation you hvae provided. As you said, (*** The current batch of statements is composed of all statements entered since the last GO....***) I...

    --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:04 pm

    #976785

  • 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

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