Painful datetime conversion

  • Wayne West (9/25/2015)


    Sean Lange (9/17/2015)


    ... I would rather peel M&Ms in the desert than work with this system.

    Sounds like the ERP system used by a previous employer. I told my friends that the name of That Vendor would never appear on my resume or my LinkedIn profile, and it hasn't. I started a new job and found out that their accounting system had been bought out by That Vendor.

    *sigh* Sometimes you just can't get away from certain people/things. I only hope that the division managing our system is different than their ERP division.

    I found out that at that previous employer that the vendor took over managing several other systems, which included disabling my DBCCs, log monitoring, etc. That Vendor didn't notice an error creep in and lost a couple of months of data.

    Congratulations (and more than a bit jealous) that you were able to get away from that menace!!!

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Sean Lange (9/25/2015)


    Wayne West (9/25/2015)


    Sean Lange (9/17/2015)


    ... I would rather peel M&Ms in the desert than work with this system.

    Sounds like the ERP system used by a previous employer. I told my friends that the name of That Vendor would never appear on my resume or my LinkedIn profile, and it hasn't. I started a new job and found out that their accounting system had been bought out by That Vendor.

    *sigh* Sometimes you just can't get away from certain people/things. I only hope that the division managing our system is different than their ERP division.

    I found out that at that previous employer that the vendor took over managing several other systems, which included disabling my DBCCs, log monitoring, etc. That Vendor didn't notice an error creep in and lost a couple of months of data.

    Congratulations (and more than a bit jealous) that you were able to get away from that menace!!!

    Yeah, I have an ERP that's a 4-letter word (in every sense of the word) in my past, too. Given that Sean is now working with Baan that's been sold and morphed a few times, I do not envy the situation at all. The names may have changed to protect the guilty, but the core is still there.

    Sean, I feel your pain. I hope that someday you have the pleasure of trying to forget the nightmares.

  • Eirikur Eiriksson (9/25/2015)


    Jeff, did you figure out why your dev box was/is 3 times slower than the smallest amazon RDS instance?

    😎

    Not yet but we did figure out why my backups were crawling (6 times slower) on the new backup box. The cables were too long and, to make things neater, they back-looped them several times (clothesline style) and tie-wrapped them nice and tight especially at the U-turns. That the best way I know of to change 100GB cable runs to something similar to 10-base-T with a coffee pot on the same power plug (different but true story). 😛 Might have similar problems elsewhere because the same folks did all the cables. :sick:

    --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)
    Intro to Tally Tables and Functions

Viewing 3 posts - 61 through 63 (of 63 total)

You must be logged in to reply to this topic. Login to reply