Forum Replies Created

Viewing 15 posts - 45,436 through 45,450 (of 59,101 total)

  • 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

  • RE: Select all months bewtween two dates

    GSquared (1/29/2009)

    Ouch! Yeah, that piece of code might work, but it hurts to look at!

    ;with Numbers (Number) as

    (select row_number() over (order by object_id)

    from sys.all_objects)

    select dateadd(month, number, @StartDate)

    from Numbers

    where number...

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

    #935127

  • RE: SQL or Oracle

    GSquared (1/29/2009)

    I like triggers. They make firearms much more user friendly than keyboards and mice would. 🙂

    Heh... firearms... the original point and click device 😛

    But incompetent devs as 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 29, 2009 at 2:40 pm

    #935099

  • RE: Celebration

    Funny thing... you don't look a million members old. 😛 Congratulations Steve, SSC, and RedGate!

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

    #934384

  • RE: Get 2nd Occurence

    Absolutely my pleasure, Trigger. Heh... thinking out side the box... a phrase I coined goes as follows...

    [font="Arial Black"]Before you can think outside the box, you must first realize... you're...

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

    #934383

  • RE: Temp Tables vs. Physical Tables

    Sorry... didn't say it quite the right way... I meant that the real problem code they were trying to fix at my old company didn't budge... aggregate views of aggregate...

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

    #934358

  • RE: Temp Tables vs. Physical Tables

    Funny how people keep trying to optimize hardware... the code is the great divide... I've seen servers with all those wonder changes to the hardware occur... and the code didn'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 28, 2009 at 6:30 pm

    #934353

  • RE: Trying to rewrite RBAR Function

    Thank you, Sir. Glad to see you got the test data generator working, as well. I appreciate the performance report on that, as well.

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

    #934350

  • RE: Get 2nd Occurence

    No problem... especially since the write-up in BOL leaves a lot for the reader to discover.

    PARSENAME was designed to parse the 1 to 4 part object names (usually tables or...

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

    #934346

  • RE: SQL or Oracle

    bruce.cassidy (1/28/2009)

    [font="Verdana"]The Oracle create trigger syntax is as follows:[/font]

    [font="Courier New"]

    CREATE [OR REPLACE] TRIGGER

    {BEFORE|AFTER} {INSERT|DELETE|UPDATE} ON

    [REFERENCING [NEW AS ...

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

    #934342

Viewing 15 posts - 45,436 through 45,450 (of 59,101 total)