What was your most unorthodox system design decision?

Question

Question by MladenPrajdic · Oct 07, 2009 at 03:31 PM · database database-design

What was your most unorthodox system design decision?

As i was writing this blog on Surrogate and Natural keys i started wondering... what was your most unorthodox system design decision? be it SQL server, Sharepoint, CRM, Network, etc...

Mine was droping the complete codebase of a project in it's 3rd iteration and starting over.

1

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2009-10-08T00:30:37Z

Best Answer

Answer by robvolk · Oct 08, 2009 at 12:30 AM

I did something like that, a project I worked on for 2 weeks but felt it wasn't quite right. I had a glimmer of an idea on Thursday but couldn't flesh it out. I didn't work on it Friday, then went into the office on Saturday and Sunday and knocked it out. DB, app code and UI all redone in about 18-20 hours.

The really unorthodox thing about it were my tables...no surrogate keys. :) I had one table with 5 or 6 columns, and they were all part of the primary key. Most of the tables were like that, very few non-key columns. I was in Chris Date mode back then, not long after I wrote my infamous Identity column article, and this app just happened to fit theory pretty well.

I wouldn't do it that way today though.

2 · Share

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

What was your most unorthodox system design decision?

1 Reply

Your answer

Follow this Question

Related Questions