Forum Replies Created

Viewing 15 posts - 45,421 through 45,435 (of 59,095 total)

  • RE: CLR Running in Mirrored Environment

    Jonathan Kehayias (1/28/2009)

    Does it really matter for the context of the question posed in this thread?

    Your aversion to CLR takes every thread in this forum completely off topic...

    --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 29, 2009 at 9:44 pm

    #935275

  • RE: Linking to the Previous Row

    David McKinney (1/25/2009)

    As Peter pointed out a few posts ago, a CTE is more akin to a subquery than a temp table, in that it is constructed when it 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)

    January 29, 2009 at 9:25 pm

    #935272

  • RE: Celebration

    Lynn Pettis (1/29/2009)

    Hmmm, so Cardinal Moden, a realist you are.

    Heh... nope... I saw that in the pork chop bones on my dinner plate. 😛

    --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 29, 2009 at 9:15 pm

    #935265

  • RE: Earning Credit

    Then, you've got some pretty good teachers. In a lot of places, either the teachers aren't so good as to hand out their personal contact numbers, or they don't...

    --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 29, 2009 at 9:06 pm

    #935258

  • RE: Are the posted questions getting worse?

    Bruce W Cassidy (1/29/2009)

    Jeff Moden (1/29/2009)

    would you post the URL for the thread you quoted me on, please?

    "The Post"

    [font="Verdana"]For the URL of the thread... just look up. Yep,...

    --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 29, 2009 at 9:00 pm

    #935256

  • RE: Get 2nd Occurence

    Trigger (1/29/2009)

    Well said Jeff!

    I will remember this saying!

    Heh... thanks Trigger... I've got a bunch more, but having been in the Navy, most of them aren't suitable to publish here. 😛

    --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 29, 2009 at 8:36 pm

    #935250

  • RE: Get 2nd Occurence

    smeet.sinha (1/28/2009)

    U r exceptional Jeff

    no more comments ........

    Thanks for the thoughtful comment, Smeet...

    By the way, did you ever find a work around concerning executing dynamic SQL in a function?

    --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 29, 2009 at 8:35 pm

    #935249

  • RE: What are the Party Plans?

    jgrubb (1/29/2009)

    Completely Off-Topic, I wanted to see who started the Pork Chop thing,

    Heh... do you really have to wonder? 😛

    --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 29, 2009 at 8:19 pm

    #935242

  • RE: Earning Credit

    While I absolutely agree that parents should be deeply involved in their kids schooling, not all parents can take the time off from work like you did, Lynn... especially in...

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

    #935235

  • RE: How can you supress the dash line in the output

    jcrawf02 (1/29/2009)

    Jeff Moden (1/27/2009)

    ... Hammer and Chisel? What? 😉

    lol - cuneiform?

    Heh... :hehe: obviously, a lost language, as well. The OP just refuses to answer a simple question... too...

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

    #935234

  • RE: Determining whether a Stored Procedure returns a resultset

    PhilPacha (1/29/2009)

    Jeff, does that mean you're aware of a 'non-easy' method for determining whether a Stored Procedure returns a resultset? And, no, I don't see any dilema; we're interested...

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

    #935232

  • RE: Trying to rewrite RBAR Function

    Matt Miller and I did some pretty good testing on that idea in the past... can't find the posts anymore... they may have been lost in the "move". Bottom...

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

    #935227

  • RE: Manual or auto - growth of datafiles

    aali_online (1/29/2009)

    Sorry Jeff, I did not check me previous reply:

    How do you figure that the speed of the disk has anything at all to do with disk fragmentation?

    --Jeff Moden

    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)

    January 29, 2009 at 6:43 pm

    #935217

  • RE: Celebration

    anam (1/29/2009)

    Brad M. McGehee (1/29/2009)

    Can any of you math majors calculate what the number of members SSC could potentially have if the site continues to grow at the current rate...

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

    #935212

  • RE: Are the posted questions getting worse?

    Bruce W Cassidy (1/29/2009)

    Jeff Moden (11/22/2008)

    2. Should a senior DBA be able to answer those questions without having to resort to a forum?

    [font="Verdana"]In my experience, a "senior" role isn't...

    --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 29, 2009 at 6:23 pm

    #935211

Viewing 15 posts - 45,421 through 45,435 (of 59,095 total)