Forum Replies Created

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

  • 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

  • RE: Determining whether a Stored Procedure returns a resultset

    I don't believe there's an easy way to do that, all though I could certainly be wrong. The fly in the ointment is what happens if a sproc returns...

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

    #934341

  • RE: A stored Proc inside a cursor inside a trigger

    ian McCann (1/28/2009)

    Thanks Lynn

    I don't think I explained my needs very well.

    My problem is not in fixing this ( I am actually looking forward to working with a tally table...

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

    #934257

  • RE: Consecutive timespan

    Christopher,

    Andrew is correct... take a look at the link in my signature below to help us help you. Thanks.

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

    #934251

  • RE: GUID not unique

    timscronin (1/28/2009)

    If you were going to convert a guid to a varchar would the conversion not be a varchar(36)?

    Probably not... since all GUID's are 36 characters, why not save the...

    --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 2:58 pm

    #934246

  • RE: Manual or auto - growth of datafiles

    There's only one thing that ultimately affects fragmentation... that's growth of files. Whether you set it manually or automatically, it's file growth. The best thing to do 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 28, 2009 at 2:47 pm

    #934235

  • RE: Manual or auto - growth of datafiles

    aali_online (1/28/2009)

    Fragmentation will depend on the speed of the disk subsystem

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

    --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 2:43 pm

    #934232

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