Forum Replies Created

Viewing 15 posts - 39,661 through 39,675 (of 59,072 total)

  • 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

  • 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

Viewing 15 posts - 39,661 through 39,675 (of 59,072 total)