Forum Replies Created

Viewing 15 posts - 39,691 through 39,705 (of 59,098 total)

  • RE: FizzBuzz

    reidres (2/22/2010)

    Jeff,

    Thanks for the heads up on the fact that it can be done without tables. I now see the solution. To just generate and count the numbers...

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

    #1123341

  • RE: FizzBuzz

    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 may....

    --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 3:43 pm

    #1123333

  • RE: FizzBuzz

    reidres (2/22/2010)

    Well I have to dispute the scalability of Jeff's implied solution and also think it is clunky and not intuitive. If we are to add scalability and speed...

    --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 2:27 pm

    #1123284

  • RE: FizzBuzz

    Ivanna Noh (2/22/2010)

    it won't scale much, but that wasn't part of the original spec

    🙂

    Writing scalable code should be an "implied" requirement for all Developers. 😉

    --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 1:03 pm

    #1123218

  • RE: Today's Random Word!

    Heh... it's more like a having a blowfly fly up your nose. 😛 Everyone tries to install handrails on me about that problem because they don't understand that...

    --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 12:37 pm

    #1123203

  • RE: FizzBuzz

    Sean-752587 (2/22/2010)

    Jason and Jeff

    As far as scaleability is concerned, I did try it with 1 Mil. rows which didn't work in my master database (SQL 2008 dev edition). It topped...

    --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 12:31 pm

    #1123200

  • RE: Today's Random Word!

    FizzBuzz 😛

    --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 12:16 pm

    #1123183

  • RE: FizzBuzz

    Sean-752587 (2/22/2010)

    So I think the lesson learned for me, is that I need to put a bit more effort into the way I approach problem solving and I need 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)

    February 22, 2010 at 10:59 am

    #1123136

  • RE: FizzBuzz

    jcrawf02 (2/22/2010)

    Agree with Gus on the self-documentation, makes it clearer WHY you're doing it. Comments could do that too, suppose.

    Sean, on yours, casting is unneccessary until the ELSE, and makes...

    --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 10:55 am

    #1123131

  • RE: FizzBuzz

    Sean-752587 (2/22/2010)

    It did take me a fair bit longer than 10 minutes, but I think the result is a good one. At first I was working with number tables (as...

    --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 10:54 am

    #1123129

  • RE: FizzBuzz

    CirquedeSQLeil (2/22/2010)

    jcrawf02 (2/22/2010)

    Agree with Gus on the self-documentation, makes it clearer WHY you're doing it. Comments could do that too, suppose.

    Sean, on yours, casting is unneccessary until the ELSE, 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)

    February 22, 2010 at 10:50 am

    #1123128

  • RE: FizzBuzz

    Steve Jones - Editor (2/22/2010)

    All things being equal, you pick the guy with the set based solution. However I've rarely seen "all things equal" between two candidates in an interview....

    --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 9:08 am

    #1123033

  • RE: FizzBuzz

    Steve Jones - Editor (2/22/2010)

    Jeff Moden (2/22/2010)

    ... which one do you think I'll pick?

    The one that says pork chop the most :w00t:

    Heh... nope... the one that brings 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)

    February 22, 2010 at 9:07 am

    #1123031

  • RE: FizzBuzz

    John Burris (2/22/2010)

    OK Jeff, I did the original problem in about 4 minutes. I thought it was good, but then I read the first 1/3 of your article....

    --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 9:05 am

    #1123029

  • RE: FizzBuzz

    J.Faehrmann (2/22/2010)

    No offence taken, Jeff. But you made me think about my habits, thanks for that 🙂

    Being lazy and pragmatic is a very important developer attitude to me.

    I never...

    --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 8:58 am

    #1123025

Viewing 15 posts - 39,691 through 39,705 (of 59,098 total)