Forum Replies Created

Viewing 15 posts - 43,636 through 43,650 (of 59,097 total)

  • RE: No More SOX

    wldhrs (6/1/2009)

    Jeff Moden (5/31/2009)

    "Its the Law"

    A four word reason "It's the law".

    I soooo dislike misuse of the apostrophe in possessive case, particularly of the verb "to be".

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

    June 1, 2009 at 8:54 pm

    #1003134

  • RE: Are the posted questions getting worse?

    And, yeah... I'm glad your kid is OK and that some good folks pitched in. Just no more lectures about how good people are and how much they love...

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

    #1003132

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/1/2009)

    When we, as Americans, listen to the news we hear how much of the world seems to hate us. What we don't realize is that it isn't...

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

    #1003131

  • RE: Significance of Partitioning on Two Related Tables

    Seems to me that unless you balance the partitions across separate spindles, the only benefit for performance more than what a proper clustered index with proper maintenance would be 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)

    June 1, 2009 at 8:34 pm

    #1003130

  • 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

Viewing 15 posts - 43,636 through 43,650 (of 59,097 total)