Forum Replies Created

Viewing 15 posts - 51,346 through 51,360 (of 59,102 total)

  • 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

  • RE: PK / FK design question

    Moral: even if you decide to combine subtypes in the transaction table, write your SQL as if they were separate tables.

    Heh... moral of the story should be that 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:15 pm

    #796848

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

    TheSQLGuru (4/1/2008)

    Here is my take on reusability:

    1) most code doesn't actually GET reused because a) all devs don't know about it, b) devs don't bother checking to see if their...

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

    #796844

  • RE: When to use a cursor

    SQLZ (4/1/2008)

    The trick is in knowing when to use them.

    That is absolutely correct! The problem is that most people simply give up too soon!

    When a developer comes to me...

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

    #796839

  • RE: When to use a cursor

    Heh... Karl... no wonder that it appears that your cursor beats the function... your cursor doesn't do the same thing/produce the same row set... I'm working on 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)

    April 1, 2008 at 1:35 pm

    #796827

Viewing 15 posts - 51,346 through 51,360 (of 59,102 total)