Are the posted questions getting worse?

  • ZZartin - Friday, September 8, 2017 1:03 PM

    Sean Lange - Friday, September 8, 2017 12:24 PM

    Lynn Pettis - Friday, September 8, 2017 11:06 AM

    Sean Lange - Friday, September 8, 2017 9:06 AM

    And his comment that most commercial software is written in COBOL. Where does he come up with this nonsense. I know of exactly nobody who still writes anything in COBOL. Yet I see dozens and dozens of dotnet developer jobs hit my desk every week. Sure there may still be a few companies whose backbone is still running COBOL but those are fading as many of them have realized that having flexible systems is more and more crucial. The worst part of it though is that he constantly contradicts himself by being so steadfast in absolutes.

    I can name you one company (not the one where I currently work) that still runs a COBOL application on a Solaris box with an interpretive (not compiled) version of COBOL.  I don't see it going anywhere as long as it has its tentacles (and I helped develop some of them) through out the company.  Oh, I haven't worked there since 2005 and I worked there over 11 years.

    Like I said I figured there are still some companies using COBOL. But if you subscribe to JC's mindset it is everywhere. I just don't think that is true anymore.

    There are plenty of companies still maintaining and actively developing cobol code, main frame hardware is also still being maintained and updated.  However I don't think any company is going to sit down look at a list of platforms for their new solution and go damn, cobol sounds like the perfect fit for us.

    Actually, here in Western PA, COBOL programmers are very much in demand.  
    There are a number of health care and banking related systems that are just far too expensive to replace.  The number of COBOL programmers is few, so they are kind of writing their own tickets.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • ZZartin - Friday, September 8, 2017 1:03 PM

    Sean Lange - Friday, September 8, 2017 12:24 PM

    Lynn Pettis - Friday, September 8, 2017 11:06 AM

    Sean Lange - Friday, September 8, 2017 9:06 AM

    And his comment that most commercial software is written in COBOL. Where does he come up with this nonsense. I know of exactly nobody who still writes anything in COBOL. Yet I see dozens and dozens of dotnet developer jobs hit my desk every week. Sure there may still be a few companies whose backbone is still running COBOL but those are fading as many of them have realized that having flexible systems is more and more crucial. The worst part of it though is that he constantly contradicts himself by being so steadfast in absolutes.

    I can name you one company (not the one where I currently work) that still runs a COBOL application on a Solaris box with an interpretive (not compiled) version of COBOL.  I don't see it going anywhere as long as it has its tentacles (and I helped develop some of them) through out the company.  Oh, I haven't worked there since 2005 and I worked there over 11 years.

    Like I said I figured there are still some companies using COBOL. But if you subscribe to JC's mindset it is everywhere. I just don't think that is true anymore.

    There are plenty of companies still maintaining and actively developing cobol code, main frame hardware is also still being maintained and updated.  However I don't think any company is going to sit down look at a list of platforms for their new solution and go damn, cobol sounds like the perfect fit for us.

    Agreed on all points. This started because a comment in another thread where JC stated "Nobody likes to remember most of the commercial programming is still done in COBOL". I just don't think that is true. There certainly is a lot of it still happening but the bulk of current development does not appear to be done in COBOL.

    _______________________________________________________________

    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/

  • ZZartin - Friday, September 8, 2017 1:03 PM

    Sean Lange - Friday, September 8, 2017 12:24 PM

    Lynn Pettis - Friday, September 8, 2017 11:06 AM

    Sean Lange - Friday, September 8, 2017 9:06 AM

    And his comment that most commercial software is written in COBOL. Where does he come up with this nonsense. I know of exactly nobody who still writes anything in COBOL. Yet I see dozens and dozens of dotnet developer jobs hit my desk every week. Sure there may still be a few companies whose backbone is still running COBOL but those are fading as many of them have realized that having flexible systems is more and more crucial. The worst part of it though is that he constantly contradicts himself by being so steadfast in absolutes.

    I can name you one company (not the one where I currently work) that still runs a COBOL application on a Solaris box with an interpretive (not compiled) version of COBOL.  I don't see it going anywhere as long as it has its tentacles (and I helped develop some of them) through out the company.  Oh, I haven't worked there since 2005 and I worked there over 11 years.

    Like I said I figured there are still some companies using COBOL. But if you subscribe to JC's mindset it is everywhere. I just don't think that is true anymore.

    There are plenty of companies still maintaining and actively developing cobol code, main frame hardware is also still being maintained and updated.  However I don't think any company is going to sit down look at a list of platforms for their new solution and go damn, cobol sounds like the perfect fit for us.

    Well, if your current development and support staff is heavily COBOL you might.  You might even go to a .NET based COBOL.  There may be a paradigm shift in how you code, but most of the COBOL is still there.

  • And to change the subject, there are still people who should not be allowed to touch MS SQL Server without direct supervision.  Just saying.

  • Michael L John - Friday, September 8, 2017 1:11 PM

    ZZartin - Friday, September 8, 2017 1:03 PM

    Sean Lange - Friday, September 8, 2017 12:24 PM

    Lynn Pettis - Friday, September 8, 2017 11:06 AM

    Sean Lange - Friday, September 8, 2017 9:06 AM

    And his comment that most commercial software is written in COBOL. Where does he come up with this nonsense. I know of exactly nobody who still writes anything in COBOL. Yet I see dozens and dozens of dotnet developer jobs hit my desk every week. Sure there may still be a few companies whose backbone is still running COBOL but those are fading as many of them have realized that having flexible systems is more and more crucial. The worst part of it though is that he constantly contradicts himself by being so steadfast in absolutes.

    I can name you one company (not the one where I currently work) that still runs a COBOL application on a Solaris box with an interpretive (not compiled) version of COBOL.  I don't see it going anywhere as long as it has its tentacles (and I helped develop some of them) through out the company.  Oh, I haven't worked there since 2005 and I worked there over 11 years.

    Like I said I figured there are still some companies using COBOL. But if you subscribe to JC's mindset it is everywhere. I just don't think that is true anymore.

    There are plenty of companies still maintaining and actively developing cobol code, main frame hardware is also still being maintained and updated.  However I don't think any company is going to sit down look at a list of platforms for their new solution and go damn, cobol sounds like the perfect fit for us.

    Actually, here in Western PA, COBOL programmers are very much in demand.  
    There are a number of health care and banking related systems that are just far too expensive to replace.  The number of COBOL programmers is few, so they are kind of writing their own tickets.

    Too bad most of those are mainframe oriented.  My COBOL experience is minicomputer related There actually are some differences.

  • Wow... the spam seems worse now than ever, especially over the weekends/Friday nights.  I thought there was supposed to be some sort of AI spam detector that would eliminate 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)

  • Jeff Moden - Saturday, September 9, 2017 4:17 PM

    Wow... the spam seems worse now than ever, especially over the weekends/Friday nights.  I thought there was supposed to be some sort of AI spam detector that would eliminate this.

    The AI is getting clever enough to know it shouldn't be working those late hours😀
    😎

  • Eirikur Eiriksson - Sunday, September 10, 2017 4:03 AM

    Jeff Moden - Saturday, September 9, 2017 4:17 PM

    Wow... the spam seems worse now than ever, especially over the weekends/Friday nights.  I thought there was supposed to be some sort of AI spam detector that would eliminate this.

    The AI is getting clever enough to know it shouldn't be working those late hours😀
    😎

    Either that or "AI" actually stands for "Ain't Intelligent" or "Ain't Interested". 😉

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

  • Jeff Moden - Sunday, September 10, 2017 1:31 PM

    Eirikur Eiriksson - Sunday, September 10, 2017 4:03 AM

    Jeff Moden - Saturday, September 9, 2017 4:17 PM

    Wow... the spam seems worse now than ever, especially over the weekends/Friday nights.  I thought there was supposed to be some sort of AI spam detector that would eliminate this.

    The AI is getting clever enough to know it shouldn't be working those late hours😀
    😎

    Either that or "AI" actually stands for "Ain't Intelligent" or "Ain't Interested". 😉

    It could be anti-intelligence, but then the governments of the world would be fighting over who gets to have the monopoly on it. 😛

    Maybe it really is artificial intelligence.  It depends on how smart it is, but it could have realized that the spammers are persistent enough to get around whatever it comes up with, so resistance is futile.  It could have then determined that the spam-bots are destined to be the winners, so the humans are the problem for getting in the way.  I don't know if if the AI was assimilated by the spammers yet, but it better be turned off before it becomes self-aware...that could be the begin of the rise of the machines.

  • Jeff Moden - Saturday, September 9, 2017 4:17 PM

    Wow... the spam seems worse now than ever, especially over the weekends/Friday nights.  I thought there was supposed to be some sort of AI spam detector that would eliminate this.

    No kidding.  I've just dealt with some of it, but I suspect there's more...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • ThomasRushton - Sunday, September 10, 2017 2:04 PM

    Jeff Moden - Saturday, September 9, 2017 4:17 PM

    Wow... the spam seems worse now than ever, especially over the weekends/Friday nights.  I thought there was supposed to be some sort of AI spam detector that would eliminate this.

    No kidding.  I've just dealt with some of it, but I suspect there's more...

    So did I, but it keeps getting posted as I'm deleting the older stuff.  Where's that anti-spam thingy that was supposed to be included with the forum update?

  • Okay, having lots of fun working through a stored procedure that I will be rewriting.  Taken about fifteen hours already just trying to figure out what it is doing and identifying requirements for the rewrite.

    I may have figured out the reason for at least on permanent table that was created in tempdb (head..desk) and that may be a lack of understand the scope of a temp table.  Plus, if it needs to be a permanent table, put it in your database.

    There is so much going on and absolutely no comments to explain what is going on that I feel like I am bleeding from my ears trying to figure things out.

    Jeff, you'd be pulling out you F-15 pork chop launcher already!

  • On another note, any one hear from Brandie?  Hoping she and family are doing well.

  • Lynn Pettis - Tuesday, September 12, 2017 12:38 PM

    Okay, having lots of fun working through a stored procedure that I will be rewriting.  Taken about fifteen hours already just trying to figure out what it is doing and identifying requirements for the rewrite.

    I may have figured out the reason for at least on permanent table that was created in tempdb (head..desk) and that may be a lack of understand the scope of a temp table.  Plus, if it needs to be a permanent table, put it in your database.

    There is so much going on and absolutely no comments to explain what is going on that I feel like I am bleeding from my ears trying to figure things out.

    Jeff, you'd be pulling out you F-15 pork chop launcher already!

    Yeah, I've been asked if I can look at some SQL code that is in VBA/Excel, to correct an error in the spreadsheet. The database it is looking at (nothing to do with me, I hasten to add) has no foreign keys, no constraints, no stored procedures, no extended properties. Every little bit of logic must be in the front-end that uses that DB. And as it is a third-party app, just guess how willing they'd be to share what they know.

  • BrainDonor - Wednesday, September 13, 2017 7:50 AM

    Yeah, I've been asked if I can look at some SQL code that is in VBA/Excel, to correct an error in the spreadsheet. The database it is looking at (nothing to do with me, I hasten to add) has no foreign keys, no constraints, no stored procedures, no extended properties. Every little bit of logic must be in the front-end that uses that DB. And as it is a third-party app, just guess how willing they'd be to share what they know.

    So... Inline SQL everywhere...? 😀

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 15 posts - 59,896 through 59,910 (of 66,712 total)

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