Click here to Skip to main content
15,887,477 members

The Weird and The Wonderful

   

The Weird and The Wonderful forum is a place to post Coding Horrors, Worst Practices, and the occasional flash of brilliance.

We all come across code that simply boggles the mind. Lazy kludges, embarrassing mistakes, horrid workarounds and developers just not quite getting it. And then somedays we come across - or write - the truly sublime.

Post your Best, your worst, and your most interesting. But please - no programming questions . This forum is purely for amusement and discussions on code snippets. All actual programming questions will be removed.

 
GeneralRe: Simply not Normalisation Cricket. Pin
Brady Kelly16-Dec-11 1:48
Brady Kelly16-Dec-11 1:48 
GeneralRe: Simply not Normalisation Cricket. Pin
Mike Marynowski16-Dec-11 12:35
professionalMike Marynowski16-Dec-11 12:35 
GeneralRe: Simply not Normalisation Cricket. Pin
Florin Jurcovici17-Dec-11 4:05
Florin Jurcovici17-Dec-11 4:05 
GeneralRe: Simply not Normalisation Cricket. Pin
Brady Kelly17-Dec-11 4:10
Brady Kelly17-Dec-11 4:10 
GeneralRe: Simply not Normalisation Cricket. Pin
interarticle17-Dec-11 22:22
interarticle17-Dec-11 22:22 
GeneralRe: Simply not Normalisation Cricket. Pin
Tom Chantler16-Dec-11 1:54
professionalTom Chantler16-Dec-11 1:54 
GeneralRe: Simply not Normalisation Cricket. Pin
Klae16-Dec-11 4:45
Klae16-Dec-11 4:45 
GeneralRe: Simply not Normalisation Cricket. Pin
A_WoodApple16-Dec-11 5:56
A_WoodApple16-Dec-11 5:56 
Hmm... I have been working with relational databases for 15 years and....
I have been guilty of all the things you mention at one time or another.

Yes, there are certain standards that are accepted but... when you have to make a database system work in a real live enviroment... sometimes things that seem rather absurd really make a lot of sense. These things are often done in order to improve proformance or to allow data from a legacy system to be used. Storing data/sums/calculations in a table can improve proformance if the they seldom change and you have a good way to batch update these values during off hours.(or just calculate them once when the record is created not everytime anyone wants to view that data) I have used an always true bool/bit value in some systems in order to relate all values from one table to another(although it has seldom been required in recent years as the tools have often changed to deal with this).

The biggest problem with doing these things is not that they don't work (often these things make the system run better... sometimes a lot lot better) but because if you don't know why something was done, it is hard for anyone else but the designer to safely change anything and can become a maintaince nightmare. (and without the designer or someone very famillar with the system... it might be better to throw it all out and start over with the basics... a long hard road)
This post was written by a gorilla mashing the keyboard.


modified 16-Dec-11 13:04pm.

GeneralRe: Simply not Normalisation Cricket. Pin
Florin Jurcovici17-Dec-11 4:12
Florin Jurcovici17-Dec-11 4:12 
GeneralRe: Simply not Normalisation Cricket. Pin
Allan Thomas17-Dec-11 1:47
Allan Thomas17-Dec-11 1:47 
GeneralConverting a string to an int PinPopular
Shameel13-Dec-11 8:19
professionalShameel13-Dec-11 8:19 
GeneralRe: Converting a string to an int PinPopular
GibbleCH13-Dec-11 10:09
GibbleCH13-Dec-11 10:09 
GeneralRe: Converting a string to an int Pin
Shameel13-Dec-11 17:47
professionalShameel13-Dec-11 17:47 
GeneralRe: Converting a string to an int Pin
PIEBALDconsult13-Dec-11 15:48
mvePIEBALDconsult13-Dec-11 15:48 
GeneralRe: Converting a string to an int Pin
Shameel13-Dec-11 17:53
professionalShameel13-Dec-11 17:53 
GeneralRe: Converting a string to an int Pin
PIEBALDconsult14-Dec-11 1:49
mvePIEBALDconsult14-Dec-11 1:49 
GeneralRe: Converting a string to an int Pin
Rob Grainger15-Dec-11 22:34
Rob Grainger15-Dec-11 22:34 
GeneralRe: Converting a string to an int Pin
_Damian S_13-Dec-11 15:50
professional_Damian S_13-Dec-11 15:50 
GeneralRe: Converting a string to an int Pin
Shameel13-Dec-11 17:54
professionalShameel13-Dec-11 17:54 
GeneralRe: Converting a string to an int Pin
_Damian S_13-Dec-11 19:42
professional_Damian S_13-Dec-11 19:42 
GeneralRe: Converting a string to an int PinPopular
BobJanova13-Dec-11 23:29
BobJanova13-Dec-11 23:29 
GeneralRe: Converting a string to an int Pin
PIEBALDconsult14-Dec-11 1:51
mvePIEBALDconsult14-Dec-11 1:51 
GeneralRe: Converting a string to an int Pin
Shameel14-Dec-11 3:41
professionalShameel14-Dec-11 3:41 
GeneralRe: Converting a string to an int Pin
BobJanova14-Dec-11 3:50
BobJanova14-Dec-11 3:50 
RantDocumentation failure PinPopular
DerekT-P13-Dec-11 3:17
professionalDerekT-P13-Dec-11 3:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.