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 123»»»

The Worst Code Expand / Collapse
Author
Message
Posted Monday, March 17, 2014 8:28 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 3:06 PM
Points: 33,169, Visits: 15,304
Comments posted to this topic are about the item The Worst Code






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1551978
Posted Monday, March 17, 2014 10:54 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
All 5 fingures are not equal. The same way all developers are not equal and their skills vary based on interest, knowledge and experience. As all human are unique could not produce same result in one area but good in other area. That doesn't mean that one should able to catch their worst code. But here Jeff Atwood is mentioning about competent developer and it could be one of the ciriteria but not the only criteria to judge.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1551993
Posted Tuesday, March 18, 2014 2:17 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:34 PM
Points: 2,899, Visits: 1,797
I understand the pragmatic need to get stuff done.

One thing I have learnt about compromised solutions is that the time saved by short-cuts increments in a linear fashion (up to a point), the value of what has been delivered decreases geometrically.

Take a short cut and exclude data quality checks. Massively decrease the worth of the data.


LinkedIn Profile
Newbie on www.simple-talk.com
Post #1552050
Posted Tuesday, March 18, 2014 4:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:52 PM
Points: 5,317, Visits: 3,006
The worst code I have seen is either by the people who are so arrogant that they feel that nothing that they can do is wrong or simply don't care. I am never satisfied with my own code but sometimes achieve pride in my own work that the pragmatist in me allows. Too much satisfaction leads to complacency.

I have yet to be satisfied with an OS, application or utility. That is not to say that I haven't been impressed but that I feel that there has always been room for improvement.


Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Post #1552096
Posted Tuesday, March 18, 2014 5:33 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 4:14 AM
Points: 3,618, Visits: 5,254
Oh God Steve, don't get me started!

Good editorial!



My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.


Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1552112
Posted Tuesday, March 18, 2014 7:08 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:46 PM
Points: 1,649, Visits: 4,697
Regarding software that comes bundled with hardware, is not the actual software itself, but rather the buggy install package and the stealth marketing crap and spyware that attempts to hook into the web browser. Video device drivers are notorious for this.

The worst programming code I've seen on the job originated life as a completely different project, and then another less talented programmer (or perhaps the same programmer crunched for time) starts a new project by copying the codebase and hacking it into something else entirely. A square preg will fit into a round hole, if you hack around the edges long enough and bang it with a hammer a few times.
Post #1552159
Posted Tuesday, March 18, 2014 7:14 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 3:27 PM
Points: 21,631, Visits: 15,289

We also need those little wins that come from having our endeavors solve problems, even if we'd build software better the next time. The important thing is that you try to do better the next time.


Two important things in that quote.
1. It's great to write something that solves a problem
2. It's a good mentality to strive to become better at solving those problems and writing better code.

Great Editorial.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1552162
Posted Tuesday, March 18, 2014 7:15 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 3:27 PM
Points: 21,631, Visits: 15,289
dwain.c (3/18/2014)
Oh God Steve, don't get me started!

Good editorial!


Oh please - get started Dwain




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1552163
Posted Tuesday, March 18, 2014 9:26 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 3:06 PM
Points: 33,169, Visits: 15,304
dwain.c (3/18/2014)
Oh God Steve, don't get me started!

Good editorial!


Thanks







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1552253
Posted Tuesday, March 18, 2014 10:11 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 4:15 PM
Points: 403, Visits: 993
Well maybe close to the worst code I have ever seen was written by me. We had 16k of room to print out a large document in an old version of BASIC. I kept running out of memory space trying to print it so the code ended up with more GOTO's than sand grains in a small beach. I SWEAR there was no other way to write it but when one of the other programmers had to upgrade it to a newer version of that BASIC he was not 'happy'. I actually felt fortunate that I was his boss at the time as otherwise I would have had to upgrade the code.
Post #1552301
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse