Forum Replies Created

Viewing 15 posts - 46,171 through 46,185 (of 59,095 total)

  • RE: Corporate Software Development

    DBAdmin (1/2/2009)

    Again, my original post was not intended to say that IM has no legitimate uses. Instead, I was commenting on two things in combination, one of them being IM...

    --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 2, 2009 at 3:29 pm

    #920587

  • RE: Can you solve this sort problem?

    RBarryYoung (1/1/2009)

    Heh. Gail is much faster than me... 🙂

    Heh... while that may be true, your patience and depth of explanation are noteworthy. I'd have killed and eaten...

    --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 2, 2009 at 3:25 pm

    #920585

  • RE: identity column

    I've really got to respectfully disagree... the use of a "sequence" table of any kind will become a major hotspot, a possible source of a huge number of deadlocks, 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 2, 2009 at 3:19 pm

    #920580

  • RE: locks for generating identities

    Oh... almost forgot... the code I posted allows you to reserve more than one ID using an "increment". If you can't figure out how to use that for more...

    --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 2, 2009 at 3:08 pm

    #920574

  • RE: locks for generating identities

    mweber26 (1/2/2009)

    I need some help with an identity-type column in a table. I have a order table that has an order number field, the order number is a incrementing...

    --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 2, 2009 at 3:07 pm

    #920573

  • RE: Industry Experience... Required?

    Grant Fritchey (1/2/2009)

    Absolutely. One of the biggest problems we have where I work, an ANCIENT insurance company, is the entrenched knowledge, "We've always done it this way," even though what...

    --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 2, 2009 at 2:56 pm

    #920569

  • RE: Industry Experience... Required?

    Steve Jones - Editor (1/2/2009)

    As with everything, it depends.

    I think it's as likely that it's thrown in there to limit the candidates as it is just an addition by HR...

    --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 2, 2009 at 2:50 pm

    #920567

  • RE: Industry Experience... Required?

    bnordberg (1/1/2009)

    I agree it is a nice to have industry experience, but absolutly not necessary.

    Further I think single industry experience is a detrement. For example in healthcare (At least...

    --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 2, 2009 at 2:38 pm

    #920563

  • RE: Cursors for T-SQL Beginners

    RBarryYoung (1/2/2009)

    But when replacing cursors, we are letting go some important features that only cursors can provide to your code.

    Assuming that we are talking about SQL Server 2005/2008, I know...

    --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 2, 2009 at 2:31 pm

    #920560

  • RE: Cursors for T-SQL Beginners

    Grant Fritchey (1/2/2009)

    Let me reiterate before I whup on you some more 😉

    If that's not a fair "Pork Chops are immenent" warning, then there's no such thing. 😛

    --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 2, 2009 at 2:28 pm

    #920559

  • RE: Cursors for T-SQL Beginners

    TheSQLGuru (1/1/2009)

    I wonder if poor Mr. Wagner Crivelini is aware of the recent firestorm of posts engendered by an article writer who had the audacity to take on cursors 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)

    January 2, 2009 at 2:26 pm

    #920558

  • RE: Cursors for T-SQL Beginners

    RBarryYoung (1/2/2009)

    Jeff: I think that the URL link at the end of your last post is messed-up.

    edit: OK, you're too fast for me. Three posts back...

    Thanks, Barry.... 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 2, 2009 at 2:22 pm

    #920557

  • RE: Cursors for T-SQL Beginners

    SQLBOT (1/2/2009)

    RBarryYoung (1/2/2009)

    SQLBOT (1/2/2009)

    Can you loop through dm_db_index_physical_stats and reindex all the databases that require reindexing without an iterative structure? It's beyond my meager skills if it is possible.

    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 2, 2009 at 2:20 pm

    #920556

  • RE: Cursors for T-SQL Beginners

    LSAdvantage (1/2/2009)

    In response to sudhanvag, who stated:

    But i want a result like this

    ---------------------------------

    codName (no column name)

    abc 1 281 444 5555 , 55...

    --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 2, 2009 at 2:14 pm

    #920551

  • RE: Cursors for T-SQL Beginners

    wagner crivelini (1/2/2009)

    My point in this article is "Whenever you suspect your code is not running as expected, no matter it uses cursors or not, you should check your code's...

    --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 2, 2009 at 2:11 pm

    #920548

Viewing 15 posts - 46,171 through 46,185 (of 59,095 total)