Forum Replies Created

Viewing 15 posts - 39,676 through 39,690 (of 59,098 total)

  • RE: Help- Very Complex SQL query

    Paul White (2/22/2010)

    Jeff Moden (2/22/2010)

    I guess I didn't understand that one... it sets all the rows to 50 instead of doing the requested data smear.

    It works on my system...

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

    February 23, 2010 at 4:44 pm

    #1123978

  • RE: FizzBuzz

    Steve Jones - Editor (2/23/2010)

    Since this became a performance discussion, I added a question on ASK about the best method. I know someone might memorize this for an interview, but...

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

    February 23, 2010 at 12:57 pm

    #1123845

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

    tony rogerson (2/18/2010)

    Yes - I do mean a cursor; a static one and not a "update where current".

    I don't honestly know what your problem is here Paul - even Jeff...

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

    February 23, 2010 at 12:48 pm

    #1123836

  • RE: FizzBuzz

    Gary Varga (2/23/2010)

    Jeff Moden (2/23/2010)

    You're right, Gary... it might make a good article called "Winning the Interview with Code" or somesuch.

    OK. Perhaps two articles. The one you suggest should highlight...

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

    February 23, 2010 at 8:38 am

    #1123651

  • RE: Are the posted questions getting worse?

    jcrawf02 (2/23/2010)

    Paul White (2/23/2010)

    Jeff Moden (2/22/2010)

    Send it to me... we had a sequence table that was responsible for an average of 640 deadlocks a day before we fixed it. ...

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

    February 23, 2010 at 8:31 am

    #1123645

  • RE: Are the posted questions getting worse?

    Paul White (2/23/2010)

    Jeff Moden (2/22/2010)

    Send it to me... we had a sequence table that was responsible for an average of 640 deadlocks a day before we fixed it. I'd...

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

    February 23, 2010 at 8:28 am

    #1123643

  • RE: FizzBuzz

    Tom.Thomson (2/22/2010)

    First I tried writing a set-based solution which had to generate its numbers table (so that it would scale beyond my pre-existing tally table) and the I tried writing...

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

    February 23, 2010 at 8:10 am

    #1123622

  • RE: FizzBuzz

    Gary Varga (2/23/2010)

    Jeff,

    I have followed this thread from the start and I have read the article of yours you recommended. I was hoping to work out what solution you are...

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

    February 23, 2010 at 7:47 am

    #1123612

  • RE: FizzBuzz

    Manie Verster (2/23/2010)

    Take note, you only have to do 100 records for this interview.

    True enough... and the interviewer will send all of those people who only make it capable 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)

    February 23, 2010 at 7:18 am

    #1123593

  • RE: FizzBuzz

    Manie Verster (2/23/2010)

    Jeff I am on your case today.

    No problem, Manny... I'm on your's, as well but I did install some handrails so you can enjoy the ride. ...

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

    February 23, 2010 at 7:09 am

    #1123585

  • RE: FizzBuzz

    Manie Verster (2/23/2010)

    It is good to take a standpoint Jeff and stick to it but there is a thing called obsessiveness. I tested this query against the one I posted...

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

    February 23, 2010 at 6:44 am

    #1123566

  • RE: Are the posted questions getting worse?

    Paul White (2/22/2010)

    Steve Jones - Editor (2/22/2010)

    You certainly are, and just because there's an article out there doesn't mean we wouldn't want one here. Especially from the famous Paul White.

    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)

    February 22, 2010 at 11:16 pm

    #1123437

  • RE: store output of stored proc into temp table

    That may explain it. I'll have to do a test on 2k. Thanks, Sergiy.

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

    February 22, 2010 at 11:11 pm

    #1123435

  • RE: FizzBuzz

    John Burris (2/22/2010)

    Steve,

    I posted earlier that for 1,000,000 records I ran my first solution at 1:30 and Jeff's solution at 10 seconds. I ran the GSquared "ultimate version" on...

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

    February 22, 2010 at 4:18 pm

    #1123346

  • RE: FizzBuzz

    WayneS (2/22/2010)

    reidres (2/22/2010)

    Jeff,

    I don't want people on my team optimizing for trivial things, and the constraints of the project define those things. Speed may not be essential, or it...

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

    February 22, 2010 at 4:14 pm

    #1123343

Viewing 15 posts - 39,676 through 39,690 (of 59,098 total)