Forum Replies Created

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

  • 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

  • RE: Cursors Be Gone!

    RBarryYoung (1/3/2009)

    You know, I'm not sure how much point there is to this particular exercise. 90% of the time is in the intiial scanning of the WebLogEvents table 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)

    January 3, 2009 at 2:01 pm

    #920759

  • RE: Cursors Be Gone!

    RBarryYoung (1/3/2009)

    Jeff Moden (1/3/2009)

    Just a hint about speed... I've found that SQL Server and I both have a couple of things in common... we're both lazy and neither of us...

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

    #920756

  • RE: Cursors Be Gone!

    jacroberts (1/3/2009)

    Jeff, That's a neat way of doing it. I hadn't read up on setting working variables through update statement process so that's new to me.

    I will test both your...

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

    #920752

  • RE: Cursors Be Gone!

    Barry, coming from the likes of you, that's a totally awesome compliment. Thanks, ol' friend.

    Just a hint about speed... I've found that SQL Server and I both have 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 1:07 pm

    #920750

  • RE: identity column

    tfifield (1/3/2009)

    Jeff,

    As I pointed out the sequence table is ugly and only works for a single insert. It should only be done when there are interactive inserts done by...

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

    #920742

  • RE: Cursors for T-SQL Beginners

    RBarryYoung (1/3/2009)

    Thanks. Yeah, error-handling is a bit of a pain, but I have done it with this approach and on much more difficult ones than this (changing databases, which...

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

    #920741

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