Forum Replies Created

Viewing 15 posts - 43,606 through 43,620 (of 59,063 total)

  • RE: Handling Null's in an End_Date Column

    Cardinal say to Confusedcius 😛 one day, "To avoid pork chop, must look eye.... BIG EYE." SO! When come to fork in road, use fork on pork chop....

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

    June 1, 2009 at 8:09 pm

    #1003122

  • RE: Interview Questions.

    Jack Corbett (6/1/2009)

    Grant Fritchey (6/1/2009)

    What are the steps you will take to improve performance of a poor performing query?

    Buy my book! Kidding. There are several topics on this in 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)

    June 1, 2009 at 1:17 pm

    #1002988

  • RE: Interview Questions.

    Florian Reischl (6/1/2009)

    Jeff Moden (6/1/2009)

    Did they, by any chance, ask you how you like your pork chops cooked?

    Jeff and the meat...

    LOL!

    Heh... yeah... in this case, I'm thinking "fresh meat". 😛

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

    June 1, 2009 at 1:16 pm

    #1002987

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/1/2009)

    Grant Fritchey (6/1/2009)

    Lynn Pettis (6/1/2009)

    Great. I guess I can read them because their my articles, becuase I sure as heck didn't pay for a membership. Why...

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

    June 1, 2009 at 11:55 am

    #1002943

  • RE: Interview Questions.

    Did they, by any chance, ask you how you like your pork chops cooked?

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

    June 1, 2009 at 11:50 am

    #1002939

  • RE: Last number from a Text Field

    Ramesh (6/1/2009)

    Jeff Moden (6/1/2009)

    Bulk Insert. On a slow server, it'll load and do some data integrity checks while offloading "bad records" to a "rework file" on a 5.1 million...

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

    June 1, 2009 at 11:41 am

    #1002936

  • RE: Some Undocumented Stored Procedures

    Heh... judging from the number of forums you have this same article posted on, I'd say you have some work cut out for you in making a correction. 😉

    xp_DirTree actually...

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

    June 1, 2009 at 9:35 am

    #1002845

  • RE: Last number from a Text Field

    NathanB (5/31/2009)

    Correct, I could write it and pass it on to Data Warehousing but I honestly believe I may cause a heart-attack by suggesting that tables in this particulat Database...

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

    June 1, 2009 at 12:01 am

    #1002568

  • RE: No More SOX

    Heh... sorry... I'm holding back... I should tell you how I really feel. 😉

    --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 31, 2009 at 11:52 pm

    #1002566

  • RE: No More SOX

    SOX actually made my life a little easier. I no longer have to argue with a bunch of people about locking down the Production Servers. I no longer...

    --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 31, 2009 at 11:36 pm

    #1002561

  • RE: Last number from a Text Field

    NathanB (5/31/2009)

    antonio.collins (5/31/2009)

    P.S.: if you've got hundreds of thousands of entries and the table is growing regularly, then an explicit colum to store the derived value should be added 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 31, 2009 at 11:22 pm

    #1002559

  • RE: Last number from a Text Field

    antonio.collins (5/31/2009)

    We've had this debate before and the delimiting function's performance can practically always be improved by a hand-written piece of SQL. But the delimiting function's flexibility and simplicity...

    --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 31, 2009 at 5:40 pm

    #1002532

  • RE: Last number from a Text Field

    As a side bar, I really really hate these new code windows.... they haven't worked correctly for months now. They keep saying they're going to fix them, but they've...

    --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 31, 2009 at 10:33 am

    #1002506

  • RE: Last number from a Text Field

    antonio.collins (5/30/2009)

    NathanB (5/29/2009)

    Hey guys, been struggling with this one for a bit and about to head home, but does anyone know how I'd get "18669911.96" out of this Text field?

    "FFX...

    --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 31, 2009 at 10:23 am

    #1002504

  • RE: Last number from a Text Field

    Ramesh (5/30/2009)

    arun.sas (5/29/2009)

    Which one is better in all Situations?

    ARUN SAS

    If you read the OP's original post he has mentioned that he wanted the entire text that follows the last space.

    Though...

    --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 30, 2009 at 1:34 pm

    #1002415

Viewing 15 posts - 43,606 through 43,620 (of 59,063 total)