Forum Replies Created

Viewing 15 posts - 46,141 through 46,155 (of 59,101 total)

  • RE: Cursors Be Gone!

    battelofhalfwits (1/2/2009)

    You seem pretty sure. Have you tested it?

    Tested / Worked with = Yes

    After all of that, you've just gotta know what's coming...

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

    January 3, 2009 at 8:09 pm

    #920809

  • RE: Cursors Be Gone!

    Gaby A. (12/23/2008)

    Comments posted to this topic are about the item

    Heh... "Cursors Be Gone", indeed... see what you started? 😉 But, do try to pick a better...

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

    January 3, 2009 at 7:59 pm

    #920808

  • RE: Cursors Be Gone!

    Haroon Said (12/24/2008)

    Just for fun if you had a banking application with millions of account records in a table and had to calculate some complex interest every day on 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)

    January 3, 2009 at 7:56 pm

    #920807

  • RE: Cursors Be Gone!

    My poor ol' (but very reliable) desktop has a single 1.8 Ghz P4... it's not even a P5. But, like I said earlier, when I get something to run...

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

    January 3, 2009 at 7:45 pm

    #920805

  • RE: Cursors Be Gone!

    Matt Whitfield (1/3/2009)

    Jeff Moden (1/3/2009)

    Nope... unless you changed it for your server, the default Fill Factor is 90.

    Are you sure? On all the servers i've found, i get this result...

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

    January 3, 2009 at 5:25 pm

    #920797

  • RE: Cursors Be Gone!

    Matt Whitfield (1/3/2009)

    Ok I guess you peeps have hit the hay 🙂

    @jacroberts - can you include that last one in your test runs monday? I know it's cheating, but I...

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

    January 3, 2009 at 5:04 pm

    #920792

  • RE: Cursors Be Gone!

    Matt Whitfield (1/3/2009)

    Jeff

    You are intensely cool. 1.796. And I'll agree with what was said above - i am most impressed by the way you got the data out of 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)

    January 3, 2009 at 4:54 pm

    #920788

  • RE: Cursors Be Gone!

    Matt Whitfield (1/3/2009)

    Phil Factor (1/3/2009)

    The other thing I missed was the WITH FILLFACTOR = 100. Neat!

    Erm... I think i'm missing something. Isn't 100 the default fillfactor for any...

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

    January 3, 2009 at 4:47 pm

    #920787

  • RE: Just a Second, Guv.

    Nope... I'm right there with you on some of the pig databases, especially considering the "time elements", we've both seen in this world.

    And yes, I absolutely agree... there's 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)

    January 3, 2009 at 4:36 pm

    #920786

  • RE: Are the posted questions getting worse?

    ([font="Arial Black"]Be careful folks... [/font]if you're easily offended, there are some places on the referenced sight below that will knock your socks off.)

    Heh... Not sure how I got to 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)

    January 3, 2009 at 3:51 pm

    #920779

  • RE: Cursors for T-SQL Beginners

    I guess I do it backwards, then. I write out one "iteration" in regular code and test the willicurs out of it. Then, I just do a search...

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

    January 3, 2009 at 3:32 pm

    #920775

  • RE: Cursors Be Gone!

    jacroberts (1/3/2009)

    This method sounds like a bit of a dark art.

    Oh, it absolutely is... one that is condemned by many "experts" who have yet to get it to break. ...

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

    January 3, 2009 at 3:00 pm

    #920769

  • RE: Just a Second, Guv.

    And, yet, we go on without the ISO/IEC 9075 SQL2008 standard in SQL Server 2008 just as we have done without various other standards for zealots, lunatics, and database politicians...

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

    January 3, 2009 at 2:39 pm

    #920766

  • RE: Cursors for T-SQL Beginners

    Yeah... you're right, of course... I didn't think about those particular things... I think it's because I dream of a database where developers won't be dropping indexes out from under...

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

    January 3, 2009 at 2:14 pm

    #920762

  • RE: Cursors Be Gone!

    jacroberts (1/3/2009)

    I take is that @PrevKeep variable is redundant as it doesn't seem to be used?

    BWAA-HAAA!!! Well, at least I know someone read the code. Yes sir, I...

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

    January 3, 2009 at 2:06 pm

    #920760

Viewing 15 posts - 46,141 through 46,155 (of 59,101 total)