Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Fix v. Create Expand / Collapse
Author
Message
Posted Thursday, August 23, 2012 10:02 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 8:58 PM
Points: 31,075, Visits: 15,519
Comments posted to this topic are about the item Fix v. Create






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1349439
Posted Thursday, August 23, 2012 11:35 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 30, 2014 3:57 PM
Points: 10, Visits: 271
I have recently moved to a job where I am expected to refactor a substantial part of the code base, particulary around BI. This is new work, altough I have to document the old system along the way. Before this job however, I spent about 5 years about 90/10 in maintenance/new work. I have to say though, I like the challenge of creating new systems.
Post #1349467
Posted Friday, August 24, 2012 3:17 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:41 AM
Points: 1,593, Visits: 5,631
Steve Jones, 2012:
"The more I think about my career, the more I think that I've spent more time fixing things than actually working on new code."

Maurice Wilkes, 1949:
"As soon as we started programming, we found to our surprise that it wasn't as easy to get programs right as we had thought. Debugging had to be discovered. I can remember the exact instant when I realized that a large part of my life from then on was going to be spent in finding mistakes in my own programs."

So, you're not the first to come to this realisation!

I tend not to be involved too much in debugging SQL myself, but that's mainly because the developers of our main application work at a remote site and look after their own data. Most I've done has been to add some indexes to speed up commonly used queries.
Post #1349532
Posted Friday, August 24, 2012 4:00 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:39 AM
Points: 1,426, Visits: 1,841
For the better part of my career till date, I was working on sustenance assignments. These assignments required me to fix bugs in an application that was 10years old. Then, as parts of the application started to be re-engineered, I was pulled into cleaning-up old code and now finally, I am into developing newer areas of the application. In short, for me, it has been 80% sustenance, 20% new development.

Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
Post #1349548
Posted Friday, August 24, 2012 5:05 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, September 4, 2014 1:27 AM
Points: 841, Visits: 331
For the last five years it was more like 95/5 maintenance to new development due me supporting a well established system.
However this has changed now that we moved to a new platform, upgraded software and re-developing our ETL layer. Currently it is 70/30 with spikes of 10/90 at days.
Quite interesting to get a new system rolling and trying not to implement too many bugs to find later.
Post #1349584
Posted Friday, August 24, 2012 5:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 25, 2012 6:44 AM
Points: 1, Visits: 12
My client doesn't always no it, but I do spend quite a lot of time thinking of the best solution to a problem and sometimes I feel bad that they actually pay for that time. But thinking on the maintenance time I safe them, I do not feel bad at all. I am priviledged to spend more time designing new processes.
I would say 50/50.
The maintenance 50% is mostly working on other people's poor designs.

Raphael
Post #1349585
Posted Friday, August 24, 2012 6:37 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 26, 2014 3:27 PM
Points: 2,575, Visits: 3,872
I don't know if you'd call it fixing but I spend quite a bit of time making changes to enhance functionality; functionality that was not in the original design but someone came up with later.

Actually fixing something has been on the decline and I find myself working on new development about 60% of the time.
Post #1349613
Posted Friday, August 24, 2012 6:57 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, September 26, 2014 12:51 PM
Points: 665, Visits: 1,680
I spend most of my time fixing other peoples data/code. 50% of my work load would be reduced if people would give a $h!t, follow simple instructions or at least get some elementary training. It's to the point that I consider my current role to be buggy like one of the responders suggested to the original poster and I'm currently studying and networking to get some relief elsewhere. My current shop would score a 1 on the Joel test. Other than that, I like refactoring and maintaining code.
Post #1349620
Posted Friday, August 24, 2012 7:05 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, February 21, 2014 8:14 AM
Points: 194, Visits: 255
For the last couple of years, my job function has only been to implement new large projects. However, I still spend 10-20% fixing issues on old code as we are implementing.
Post #1349629
Posted Friday, August 24, 2012 7:24 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 3:08 PM
Points: 590, Visits: 6,744
Hm. I'd say I have about a 70/30 split of maintenance to development. At my workplace, all of the business tools in use were coded by the company's first programmer, who left earlier this year. Since the company needed a programmer suddenly, they simply asked him to learn how to code on the job, and from there he developed the programs to run most of the operations here; however, since he was essentially an amateur programmer, there's quite a few design flaws.

The biggest problem is that he didn't future-proof anything he coded, though it's understandable, as he probably didn't know how to future-proof as it was. As such, I spend a good bit of time refactoring his code and making sure it can work with our migration of data from Microsoft Access to SQL Server. In some cases, this is rather unpleasant; the C# interface that runs most of the basic tasks for the business is about 30,000 lines of code, and there's two comment "blocks" (just a sentence each!) in the whole thing. Figuring out exactly what he coded and how it works is... Complicated, at best. Especially when he used the oh-so-fun naming convention with object b having property a, and so forth, so large stretches of code turn out to be just random mishmashes of single characters. Rather tough to handle at times, but I've managed decently so far




-
Post #1349648
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse