Forum Replies Created

Viewing 15 posts - 41,026 through 41,040 (of 59,102 total)

  • RE: running total

    chandreshgeria (11/24/2009)

    appx 50000 rows

    Thank you... I'll be back after work tonight.

    --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)

    November 25, 2009 at 6:28 am

    #1083940

  • RE: running total

    Lynn Pettis (11/24/2009)

    Jeff,

    Wouldn't a million row setup show what you are talking about? Of course, you could make it ten million.

    Heh... it absolutely would... but he's using MSDE 2000...

    --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)

    November 25, 2009 at 6:27 am

    #1083939

  • RE: Update HELP

    Steve Jones - Editor (11/24/2009)

    Jeff,

    Nice post, and a great way to handle the phone numbers. I wasn't aware of NPA/NXX, and that's good to know.

    I would agree with you that...

    --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)

    November 24, 2009 at 9:50 pm

    #1083803

  • RE: Update HELP

    Garadin (11/24/2009)

    Jeff Moden (11/24/2009)

    The biggest reason is that it violates normalization and every time you do that, it will come back to haunt you sometime in the future...

    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)

    November 24, 2009 at 9:47 pm

    #1083802

  • RE: Update HELP

    Ok, Chad... totally fake it is...

    Just so folks know... an area code and exchange combination is referred to as an NPA/NXX. The letters are not random in nature...

    "N" means...

    --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)

    November 24, 2009 at 7:03 pm

    #1083770

  • RE: Update HELP

    Heh... nah... we'll do it a different way. And apologies to you and Steve... I'll blame it on the headcold and the cough medicine... just not feeling myself 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)

    November 24, 2009 at 5:44 pm

    #1083754

  • RE: Update HELP

    Jeff Moden (11/23/2009)

    cm62597 (11/23/2009)

    I have phone numbers store in my database....I am trying to create a test database that makes all the phone numbers random instead of the real ones....

    --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)

    November 24, 2009 at 4:41 pm

    #1083743

  • RE: Update HELP

    john scott miller (11/24/2009)

    update tableName

    set phonenumber = '('+cast( left( rand() * 1000,3) as varchar) + ') '

    + ''+cast( left( rand() * 1000,3) as varchar) + '-'

    + ''+cast( left(...

    --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)

    November 24, 2009 at 4:39 pm

    #1083742

  • RE: Update HELP

    Bob Hovious 24601 (11/24/2009)

    Hold on to your pork chops, Jeff. 😀

    The first thing Steve did was send him a link to a random number function. So...

    --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)

    November 24, 2009 at 4:36 pm

    #1083740

  • RE: How using SQL to generate random string?

    Garadin (11/24/2009)

    Using that format, you're lowering your pool to 16 from 36, which only gives you a total 16,777,216 possible permutations and increases your rate of failure over what was...

    --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)

    November 24, 2009 at 4:30 pm

    #1083739

  • RE: How can I improve this query or make it more consistent in execution times?

    jmartinez-847815 (11/24/2009)

    As for parameter sniffing as a possible cause, the stp on the production machine is actually accepting parameters. NOTE however that I am able to consistently replicate the performance...

    --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)

    November 24, 2009 at 4:06 pm

    #1083729

  • RE: Conversion failure with stored procedure?

    cpicard (11/24/2009)

    Thanks for all the responses. I found that the dates that were giving me issues were brought over from an old application database. The docketing people entered text into...

    --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)

    November 24, 2009 at 3:59 pm

    #1083726

  • RE: Conversion failure with stored procedure?

    cpicard (11/24/2009)

    Thanks. I'll try that out.

    (The cursor was most definitely a necessary evil. :-P)

    Heh... I'm trying to be nice... stop talking about the "C" word. Just let 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)

    November 24, 2009 at 3:58 pm

    #1083725

  • RE: CSV Files

    Jus (11/24/2009)

    Thanks Jeff for your clue on xp_DirTree..It really helps....

    You bet... thanks for the feedback.

    --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)

    November 24, 2009 at 3:54 pm

    #1083723

  • RE: CSV Files

    Vishal,

    Sorry... I'd help if I knew enough about SSIS. Perhaps this post will act as a bit of a bump.

    I will say that you should probably take a look...

    --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)

    November 24, 2009 at 3:49 pm

    #1083720

Viewing 15 posts - 41,026 through 41,040 (of 59,102 total)