Forum Replies Created

Viewing 15 posts - 51,331 through 51,345 (of 59,091 total)

  • RE: trigger not called for each record?

    Gosh, I hate the idea of replacing one form of recursion with another, but the recursive CTE will at least handle a set even if it is hidden RBAR.

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

    April 1, 2008 at 4:50 pm

    #796941

  • RE: Choosing between a View and Table-valued function

    GSquared (4/1/2008)

    The nested sets version is very fast on queries, but essentially requires either the ability to see the future, or immensely complex rebuilds to deal with that kind 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)

    April 1, 2008 at 4:44 pm

    #796937

  • RE: SQL Sleep

    Heh... you can tell I've watched way too many info-mercials! 😛

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

    April 1, 2008 at 4:29 pm

    #796930

  • RE: PK / FK design question

    Harveysburger (4/1/2008)

    Would this affect anyone's conclusion on the design?

    No... disparate transaction types should live in their own tables. Rules of normalization such as no duplicates and no nulls should...

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

    April 1, 2008 at 4:13 pm

    #796923

  • RE: When to use a cursor

    SQLZ (4/1/2008)

    Jeff Moden (4/1/2008)

    Ah ha! Finally! A challenge! If you would, post the resulting table creation script so I can duplicate what you have... the race is...

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

    April 1, 2008 at 3:49 pm

    #796908

  • RE: When to use a cursor

    matt stockham (4/1/2008)

    This is very true ... except the stepping process should be done client side using the results of a set-based query.

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

    April 1, 2008 at 3:48 pm

    #796907

  • RE: Choosing between a View and Table-valued function

    GSquared (4/1/2008)

    But what advantage would this gain in real-world use? It's more work to set up, slightly more work to maintain, and I'm not clear on the ROI 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)

    April 1, 2008 at 3:43 pm

    #796902

  • RE: SQL Sleep

    gr8scott_o (4/1/2008)

    Seriously, I would pay $40 for this... problem is my snoring would probably give me away.

    But wait! Don't order yet! If you're one of the next...

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

    April 1, 2008 at 2:50 pm

    #796870

  • RE: SQL Sleep

    Preet (4/1/2008)

    Really!

    Do you think we got nothing better to do than read pointless articles?

    Heh... well at least we know of one person who was going to buy it right...

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

    April 1, 2008 at 2:42 pm

    #796866

  • RE: trigger not called for each record?

    Matt Miller (4/1/2008)

    Jeff Moden (4/1/2008)

    Matt,

    Awesome. Can you post the test code? That sure sounds like a "keeper" to me.

    You've already seen it... right here (sorry - forgot 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)

    April 1, 2008 at 2:34 pm

    #796860

  • RE: Setting multiple values

    Rags, I've got one more "by the way"... you are using this just for a GUI passing parameters, aren't you?

    If you're trying to split a whole column of CSV's, then...

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

    April 1, 2008 at 2:31 pm

    #796857

  • RE: Setting multiple values

    Rags (3/31/2008)

    Jeff Moden (3/31/2008)

    The only thing that can be faster than the Tally Table is Dynamic SQL... but that's not a split and it does have some security issues if...

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

    April 1, 2008 at 2:28 pm

    #796856

  • RE: Setting multiple values

    J (4/1/2008)

    Jeff Moden (4/1/2008)

    Are you going to do that from a GUI where parameters are normally passed as CSV's?

    Er, is the question addressed to "Rags" or to "J" ?

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

    April 1, 2008 at 2:25 pm

    #796851

  • RE: PK / FK design question

    Outstanding set of posts on this thread, both pro and con! Thanks for the very interesting conversation and the testing that some of you have done! You guys...

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

    April 1, 2008 at 2:19 pm

    #796850

  • RE: PK / FK design question

    John Rowan (4/1/2008)

    You should see how fast things run in the NV tables when you've had the time to add the proper indexes.

    Thanks. For my example, I've only added...

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

    April 1, 2008 at 2:17 pm

    #796849

Viewing 15 posts - 51,331 through 51,345 (of 59,091 total)