Click here to Skip to main content
15,867,756 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: Best use of relational data ever Pin
ZurdoDev13-Oct-16 3:35
professionalZurdoDev13-Oct-16 3:35 
GeneralRe: Best use of relational data ever Pin
Nathan Minier13-Oct-16 3:36
professionalNathan Minier13-Oct-16 3:36 
GeneralRe: Best use of relational data ever Pin
kmoorevs13-Oct-16 3:35
kmoorevs13-Oct-16 3:35 
GeneralRe: Best use of relational data ever Pin
Nathan Minier13-Oct-16 4:00
professionalNathan Minier13-Oct-16 4:00 
GeneralRe: Best use of relational data ever Pin
charlieg13-Oct-16 3:39
charlieg13-Oct-16 3:39 
GeneralRe: Best use of relational data ever Pin
PeejayAdams13-Oct-16 5:00
PeejayAdams13-Oct-16 5:00 
GeneralRe: Best use of relational data ever Pin
Nathan Minier13-Oct-16 5:51
professionalNathan Minier13-Oct-16 5:51 
GeneralRe: Best use of relational data ever Pin
Jörgen Andersson13-Oct-16 6:55
professionalJörgen Andersson13-Oct-16 6:55 
It's a thing because the alternatives sucks.
Tally tables are a well established trick to gain performance, and we're talking huge differences here.
It's all about not using procedural code. Databases works best with sets. A tally table is a set.

Now I want you to read the conclusion in Graus's article, because it's good.
Wrong is evil and must be defeated. - Jeff Ello

GeneralRe: Best use of relational data ever Pin
User 991608013-Oct-16 7:23
professionalUser 991608013-Oct-16 7:23 
GeneralRe: Best use of relational data ever Pin
TheGreatAndPowerfulOz13-Oct-16 10:51
TheGreatAndPowerfulOz13-Oct-16 10:51 
GeneralRe: Best use of relational data ever Pin
Nathan Minier14-Oct-16 1:49
professionalNathan Minier14-Oct-16 1:49 
GeneralRe: Best use of relational data ever Pin
Jörgen Andersson14-Oct-16 2:23
professionalJörgen Andersson14-Oct-16 2:23 
GeneralRe: Best use of relational data ever Pin
Chris Maunder23-Oct-16 16:14
cofounderChris Maunder23-Oct-16 16:14 
GeneralRe: Best use of relational data ever Pin
Nathan Minier24-Oct-16 0:59
professionalNathan Minier24-Oct-16 0:59 
GeneralRe: Best use of relational data ever Pin
User 991608013-Oct-16 7:24
professionalUser 991608013-Oct-16 7:24 
GeneralRe: Best use of relational data ever Pin
PauloJuanShirt24-Oct-16 3:45
PauloJuanShirt24-Oct-16 3:45 
GeneralRe: Best use of relational data ever Pin
den2k8824-Oct-16 3:57
professionalden2k8824-Oct-16 3:57 
GeneralRe: Best use of relational data ever Pin
jgakenhe13-Oct-16 7:25
professionaljgakenhe13-Oct-16 7:25 
GeneralRe: Best use of relational data ever Pin
DerekT-P15-Nov-16 6:47
professionalDerekT-P15-Nov-16 6:47 
GeneralRe: Best use of relational data ever Pin
Brisingr Aerowing20-Nov-16 12:28
professionalBrisingr Aerowing20-Nov-16 12:28 
GeneralRe: Best use of relational data ever Pin
Manfred Rudolf Bihy21-Oct-16 6:54
professionalManfred Rudolf Bihy21-Oct-16 6:54 
GeneralI don't see sharp anymore, ... Pin
Bernhard Hiller6-Oct-16 21:27
Bernhard Hiller6-Oct-16 21:27 
GeneralRe: I don't see sharp anymore, ... Pin
Jörgen Andersson6-Oct-16 23:15
professionalJörgen Andersson6-Oct-16 23:15 
GeneralRe: I don't see sharp anymore, ... Pin
Eddy Vluggen7-Oct-16 0:32
professionalEddy Vluggen7-Oct-16 0:32 
GeneralRe: I don't see sharp anymore, ... Pin
Bernhard Hiller7-Oct-16 2:21
Bernhard Hiller7-Oct-16 2:21 

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.