I like food. I like hammers. I like bunnies.

Archive for May 1st, 2009

Table BitValue – NoYes, DisabledEnabled, FalseTrue

without comments

Screenshot from the ridiculous product

Warning- this may not be really all that funny unless you are a database administrator or a geek with the right knowledge. This rather silly product I am working with stores its data in the backend via a Microsoft SQL Server database. There’s nothing wrong with that… but on further examination of the schema I found a pretty ridiculous jewel of a table setup. Click on the picture to see the bloody details.

For those not technically inclined- this is precisely NOT how you would utilize a relational database server. It’s poor design, and rather an extreme and laughable example.

Written by Tijger Tsou

May 1st, 2009 at 4:35 pm