SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The Worst Code


The Worst Code

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

Group: Administrators
Points: 62588 Visits: 19111
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
My Blog: www.voiceofthedba.com
free_mascot
free_mascot
Hall of Fame
Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)

Group: General Forum Members
Points: 3985 Visits: 2235
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."
David.Poole
David.Poole
SSCertifiable
SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)

Group: General Forum Members
Points: 7605 Visits: 3285
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
Gary Varga
Gary Varga
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16467 Visits: 6534
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!!!
dwain.c
dwain.c
SSCertifiable
SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)

Group: General Forum Members
Points: 7291 Visits: 6431
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!
My temporal SQL musings: Calendar Tables, an Easter SQL, Time Slots and Self-maintaining, Contiguous Effective Dates in Temporal Tables
Eric M Russell
Eric M Russell
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12290 Visits: 10662
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.


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32366 Visits: 18555

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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32366 Visits: 18555
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Steve Jones
Steve Jones
SSC Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

Group: Administrators
Points: 62588 Visits: 19111
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
My Blog: www.voiceofthedba.com
John Hanrahan
John Hanrahan
SSC Eights!
SSC Eights! (805 reputation)SSC Eights! (805 reputation)SSC Eights! (805 reputation)SSC Eights! (805 reputation)SSC Eights! (805 reputation)SSC Eights! (805 reputation)SSC Eights! (805 reputation)SSC Eights! (805 reputation)

Group: General Forum Members
Points: 805 Visits: 1464
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. :-D
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search