Forum Replies Created

Viewing 15 posts - 40,996 through 41,010 (of 59,069 total)

  • 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

  • RE: running total

    chandreshgeria (11/24/2009)

    sir ,

    Depend on party turnover if 2 rows return two rows and if 200000 return 200000 with running total

    Perhaps you don't understand. I'm trying...

    --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:15 am

    #1083528

  • RE: Convert searched String to number

    Heh... you're faster than I am..

    Yes, in 2k you just swing the CTE's down into the FROM clause as "derived tables" and you've basically got the same thing. 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)

    November 24, 2009 at 8:37 am

    #1083493

  • RE: tempdb - understanding unallocated space

    Heh... you're doing one of the worst things possible. I don't know how big your TempDB was before you started shrinking it but set it to 10% larger than...

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

    #1083296

Viewing 15 posts - 40,996 through 41,010 (of 59,069 total)