Forum Replies Created

Viewing 15 posts - 45,706 through 45,720 (of 59,101 total)

  • RE: Are the posted questions getting worse?

    David Webb (1/21/2009)

    Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime. In this...

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

    #930830

  • RE: Disable and enable trigger

    amartha_dutta (1/21/2009)

    To disable / enable selective triggers...

    ALTER TABLE tableName DISABLE TRIGGER triggername

    ALTER TABLE tableName ENABLE TRIGGER triggername

    To disable / enable all triggers...

    ALTER TABLE tableName DISABLE TRIGGER ALL

    ALTER TABLE tableName ENABLE...

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

    #930827

  • RE: VM... Setting up new "box"

    Ok... still not sure what you mean, so I'll come right out and ask... Do you think I'm part of the problem on this one?

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

    #930826

  • RE: Why do people need to do this?

    RBarryYoung (1/20/2009)

    Heh, maybe I shouldn't post after midnight. But sure, use it if it helps. 😛

    Heh... gotta love it when you take the helmet off... right about midnight...

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

    #930825

  • RE: Why do people need to do this?

    Garadin (1/20/2009)

    Michael Valentine Jones (1/20/2009)

    In the end, does the reason why really matter?

    We had a meeting where we objected to a project as complete waste time and money, and were...

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

    #930824

  • RE: Why do people need to do this?

    smunson (1/21/2009)

    Jeff,

    Thanks for the validation. Barry did kind of get back at what I was saying - there's really only one reason for this kind of problem -...

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

    #930823

  • RE: Why do people need to do this?

    Dan.Humphries (1/21/2009)

    While I am new to SSIS and SQL Server I came from a sybase world and did alot of such silly requests. In all cases the sillier 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 21, 2009 at 6:34 pm

    #930822

  • RE: Why do people need to do this?

    smunson (1/21/2009)

    Oops... Looks like I messed up the quote of Jeff's post... my bad...

    Steve

    (aka smunson)

    :w00t::w00t::w00t:

    That WAS funny... I was thinking the same thing... "Heck of a tagline...

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

    #930821

  • RE: How to correctly create a Flat File on export?

    rschaeferhig (1/21/2009)

    I got it working with Ragged Right. Since there are no files in the target directory I have to set the columns up individually in Advanced, but it works....

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

    #930818

  • RE: Hidden RBAR: Triangular Joins

    David.Poole (1/21/2009)

    The first stress test showed against a comparible out-of-the-box system showed that our bespoke DB work yielded a 5x boost in performance!

    Now, that's exactly what Gus (GSquared) and 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)

    January 21, 2009 at 6:12 pm

    #930817

  • RE: 16 digit unique number

    As a side bar, 16 alpha-numeric combinations (26 letters, 10 digits = 26 different characters) would be many more combinations than most people would ever be able to use 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 21, 2009 at 5:41 pm

    #930809

  • RE: 16 digit unique number

    Crud... sorry Barry... I've been drinking hot cocoa instead of coffee. I see where you said you'd write to a temp 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 21, 2009 at 5:36 pm

    #930805

  • RE: 16 digit unique number

    RBarryYoung (1/21/2009)

    Well @@DBTS can technically do what the OP asked. Of course that is only within the scope of a single database (no mention of scope in the original...

    --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 21, 2009 at 5:25 pm

    #930799

  • RE: Loop Through every table in a DB

    RBarryYoung (1/21/2009)

    toniupstny (1/21/2009)

    The ms_foreach.. proc is an unofficial method and can be removed at the will of Bill et al. There are also cursors in the ms_foreach... ...

    --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 21, 2009 at 1:05 pm

    #930658

  • RE: 16 digit unique number

    amartha_dutta (1/21/2009)

    Dear Friend,

    How about looking into manipulating the current system date & Time.

    Use GetDate(), Remove the spaces and append with some other characters / digits of your choice (Based upon...

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

    #930622

Viewing 15 posts - 45,706 through 45,720 (of 59,101 total)