Post reply

Are the posted questions getting worse?

  • July 23, 2015 at 2:18 pm

    #1814563

    Ed Wagner (7/23/2015)

    Sean Lange (7/23/2015)

    I was just doing some work on our new ERP that we are migrating to and I nearly spit out my drink when I ran across this.

    MVXJDTA.MPDOPE.POOPNO

    Seriously that table has the "dope poop"!!!!

    I worked with a Baan system once (not my choice and it brings back very painful memories) and it had some of the strangest column names - all 4 letters in length. There were ORNO and PONO, but when we found PORN, that pushed some people over the edge. To save everyone the speculation, it was a Char(4).

    Probably all from the same old mainframe system. CONO, CUNO, CUNM etc. All the object names just make me want to take out my eyeballs and play tennis with them. This is legacy code turned into something "modern" through automated tools. The most awesome part is that there are around 5-6 thousand tables and not a single foreign key. All the RI is done in the front end. No wonder they charge for support if you insert any data anywhere. Just shoot me!!!

    _______________________________________________________________

    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/

  • July 23, 2015 at 2:20 pm

    #1814564

    Lynn Pettis (7/23/2015)

    PORN - Purchase Order Return Number

    That by itself raises "some questions":hehe:

    😎

  • July 23, 2015 at 2:22 pm

    #1814565

    Ed Wagner (7/23/2015)

    Lynn Pettis (7/23/2015)

    Ed Wagner (7/23/2015)

    Sean Lange (7/23/2015)

    I was just doing some work on our new ERP that we are migrating to and I nearly spit out my drink when I ran across this.

    MVXJDTA.MPDOPE.POOPNO

    Seriously that table has the "dope poop"!!!!

    I worked with a Baan system once (not my choice and it brings back very painful memories) and it had some of the strangest column names - all 4 letters in length. There were ORNO and PONO, but when we found PORN, that pushed some people over the edge. To save everyone the speculation, it was a Char(4).

    Let me guess:

    ORNO - Order Number

    PONO - Purchase Order Number

    PORN - Purchase Order Return Number

    Have you worked with Baan :sick: before or are you just that accustomed to ERP system column names?

    ACK!!! I just searched Baan and apparently that software is another piece of conglomerate known as Infor which is what we are migrating to. I have to say as an ERP it is pretty scary and incomplete. It is a collection of dozens and dozens of utilities that all do certain pieces. Even better is that is is obvious that most of these utilities were all written in different languages.

    _______________________________________________________________

    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/

  • July 23, 2015 at 2:22 pm

    #1814566

    Ed Wagner (7/23/2015)

    Lynn Pettis (7/23/2015)

    Ed Wagner (7/23/2015)

    Sean Lange (7/23/2015)

    I was just doing some work on our new ERP that we are migrating to and I nearly spit out my drink when I ran across this.

    MVXJDTA.MPDOPE.POOPNO

    Seriously that table has the "dope poop"!!!!

    I worked with a Baan system once (not my choice and it brings back very painful memories) and it had some of the strangest column names - all 4 letters in length. There were ORNO and PONO, but when we found PORN, that pushed some people over the edge. To save everyone the speculation, it was a Char(4).

    Let me guess:

    ORNO - Order Number

    PONO - Purchase Order Number

    PORN - Purchase Order Return Number

    Have you worked with Baan :sick: before or are you just that accustomed to ERP system column names?

    Never heard of Baan before now. Did work with an in-house COBOL/ISAM system with limited symbol space so names of columns were usually shortened to save space.

    Also helped support PeopleSoft HR and Finance systems.

  • July 23, 2015 at 2:25 pm

    #1814567

    Sean Lange (7/23/2015)

    Ed Wagner (7/23/2015)

    Sean Lange (7/23/2015)

    I was just doing some work on our new ERP that we are migrating to and I nearly spit out my drink when I ran across this.

    MVXJDTA.MPDOPE.POOPNO

    Seriously that table has the "dope poop"!!!!

    I worked with a Baan system once (not my choice and it brings back very painful memories) and it had some of the strangest column names - all 4 letters in length. There were ORNO and PONO, but when we found PORN, that pushed some people over the edge. To save everyone the speculation, it was a Char(4).

    Probably all from the same old mainframe system. CONO, CUNO, CUNM etc. All the object names just make me want to take out my eyeballs and play tennis with them. This is legacy code turned into something "modern" through automated tools. The most awesome part is that there are around 5-6 thousand tables and not a single foreign key. All the RI is done in the front end. No wonder they charge for support if you insert any data anywhere. Just shoot me!!!

    What's RI? A database is just a place to hold data. Who cares if the database can't defend itself? 😛

  • July 23, 2015 at 3:12 pm

    #1814589

    Gail, well done. Seriously impressive.

    I hope you are celebrating this weekend?

    Rodders...

  • July 23, 2015 at 4:47 pm

    #1814607

    GilaMonster (7/23/2015)

    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    Congrats again. Very impressive.

  • July 23, 2015 at 5:44 pm

    #1814614

    Sean Lange (7/23/2015)

    Ed Wagner (7/23/2015)

    Lynn Pettis (7/23/2015)

    Ed Wagner (7/23/2015)

    Sean Lange (7/23/2015)

    I was just doing some work on our new ERP that we are migrating to and I nearly spit out my drink when I ran across this.

    MVXJDTA.MPDOPE.POOPNO

    Seriously that table has the "dope poop"!!!!

    I worked with a Baan system once (not my choice and it brings back very painful memories) and it had some of the strangest column names - all 4 letters in length. There were ORNO and PONO, but when we found PORN, that pushed some people over the edge. To save everyone the speculation, it was a Char(4).

    Let me guess:

    ORNO - Order Number

    PONO - Purchase Order Number

    PORN - Purchase Order Return Number

    Have you worked with Baan :sick: before or are you just that accustomed to ERP system column names?

    ACK!!! I just searched Baan and apparently that software is another piece of conglomerate known as Infor which is what we are migrating to. I have to say as an ERP it is pretty scary and incomplete. It is a collection of dozens and dozens of utilities that all do certain pieces. Even better is that is is obvious that most of these utilities were all written in different languages.

    Well, I consider Baan a 4-letter word in every sense of the word and I would never recommend it to anyone. The language (if you can call it that) is a funky version of SQL with a bunch of other stuff thrown in and loops everywhere. I didn't have to program in it very much (thank goodness) but I had to deal with the tables in the Oracle database. No foreign keys (everything is handled in the application) and any indexing has to be done by the application itself. The tables (t$ttdsls040400, t$ttdsls041400, etc) where rough; aliases in the Oracle procedures helped a lot. It was a nightmare to install and implement and then we had to program all the stuff it couldn't do out of the box.

    Support was a complete joke. It got to the point where we didn't even bother any more. Like I said, I would never recommend it to anyone. I'm thankful I don't have to work with any more.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • July 23, 2015 at 5:59 pm

    #1814616

    Alvin Ramard (7/22/2015)

    Brandie Tarvin (7/22/2015)

    Gotta love it when someone schedules a software change/update at month end. Because "there's no impact to the business" and all that.

    <headdesk>

    This too I will survive.

    I hope.

    What's wrong with doing a software change at month end if there's no impact to the business? 😀

    😎

    If it has no impact on the business there is no justification for asking for it and certainly no justification for spending resource (even 10 man-minutes effort) on doing it. 😀

    Tom

  • July 24, 2015 at 1:22 am

    #1814646

    Steve Jones - SSC Editor (7/23/2015)

    GilaMonster (7/23/2015)

    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    Congrats again. Very impressive.

    First Class Pass - amazing.

    PhD next?

  • July 24, 2015 at 1:56 am

    #1814657

    Morning all,

    Now about to leave to catch the train to Manchester. I hope to a few of you there.

    Tom don't forget to say hi!

    Cheers,

    Rodders...

  • July 24, 2015 at 2:17 am

    #1814661

    rodjkidd (7/24/2015)

    Morning all,

    Now about to leave to catch the train to Manchester. I hope to a few of you there.

    Tom don't forget to say hi!

    Cheers,

    Rodders...

    Enjoy your stay up here.

    I'm still in the frame for shopping in Manchester rather than SQL Saturday. Mrs BWFC has said she'll buy me lunch and a pint or two though.

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

  • July 24, 2015 at 2:57 am

    #1814665

    rodjkidd (7/23/2015)

    Gail, well done. Seriously impressive.

    I hope you are celebrating this weekend?

    Taking myself and a good book to an expensive Chinese restaurant tonight. Yes, that's a celebration.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 24, 2015 at 5:31 am

    #1814698

    I see there's an article by JC on the main page today, isn't he barred? If I click on it will I not actually be able to see it, like on the forums?

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • July 24, 2015 at 5:41 am

    #1814700

    BWFC (7/24/2015)

    rodjkidd (7/24/2015)

    Morning all,

    Now about to leave to catch the train to Manchester. I hope to a few of you there.

    Tom don't forget to say hi!

    Cheers,

    Rodders...

    Enjoy your stay up here.

    I'm still in the frame for shopping in Manchester rather than SQL Saturday. Mrs BWFC has said she'll buy me lunch and a pint or two though.

    Cool, enjoy the shopping trip!

    Rodders...

Viewing 15 posts - 49,636 through 49,650 (of 66,738 total)

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