Nice SQL Table, nice kitty

Paul Watson

Michael P Butler wrote: Looks like you'll be normalizing that one for a while. Let me guess, 50 is the default value for a nvarchar field. Indeed, and on a field which contains country names which can be longer than 50 characters... so when I do matching I have to make sure it recognises cut off country names as well. :| Another fun bit is that to indicate a boolean the chap used an int. The bad bit in this is initially 1 was true and 2 was false. Then someone else came along and said 0 was true and 1 was false. Just try explaining to the client that this means there is no hope in hell of figuring out some of the records. Weeeeee! Butler, bring me a double whiskey please. :-D

Paul Watson
Bluegrass
Cape Town, South Africa

My humble photographic tribute to our world[^]

David Wulff

Paul Watson wrote: The bad bit in this is initially 1 was true and 2 was false. Then someone else came along and said 0 was true and 1 was false. Good grief man!!! What the ... oh my! EAK! :eek: I'm sorry, I need more... :omg: :wtf: :omg: :wtf: :omg: :wtf: :omg: :wtf: :wtf: :omg: :omg: :omg: :omg: :omg: :wtf: :wtf: Eak!!

David Wulff http://www.davidwulff.co.uk

Chris Austin

:omg: Fill me with your knowledge, your wisdom, your coffee.

peterchen

:ouch: Paul Watson wrote: Guess what I am doing... umm... designing the perfect example for bad table design? :cool:

Those who not hear the music think the dancers are mad. [sighist] [Agile]

peterchen

clever you!

Those who not hear the music think the dancers are mad. [sighist] [Agile]

Shog9 0

David, that was a really fucked-up story - don't be stingy with the :omg:s now!

---

Shog9 The siren sings a lonely song - of all the wants and hungers The lust of love a brute desire - the ledge of life goes under

Nick Seng

If you think you have it bad... My company uses tables with 300+ fields, and it just gets larger and larger with time. Apparently this people haven't heard of normalisation. Grrrr :Misery Loves Company: X| X| Notorious SMC

The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning Mark Twain
Get your facts first, and then you can distort them as much as you please Mark Twain

MS le Roux

And here I was thinking that one of our tables that contains 70 columns is impressively bad.

Nick Seng

I think ours started that way too, but along the process, the programmers started to add columns that were already there, bu they were too lazy to find.:mad: Notorious SMC

The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning Mark Twain
Get your facts first, and then you can distort them as much as you please Mark Twain

Roger Wright

Notorious SMC wrote: The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning Mark Twain Get your facts first, and then you can distort them as much as you please Mark Twain God made a jackass for practice, then He made a school board. Samuel Clemens "How many times do I have to flush before you go away?" - Megan Forbes, on Management (12/5/2002)

Nick Seng

Roger Wright wrote: God made a jackass for practice, then He made a school board. Samuel Clemens Mark Twain fan ? ;) Notorious SMC

The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning Mark Twain
Get your facts first, and then you can distort them as much as you please Mark Twain

Paul Watson

Notorious SMC wrote: My company uses tables with 300+ fields :eek: X| Must be fun writing stored procedures for those tables :-D 300 parameters later I would be ready to skin a cat with a pickle brush.

Paul Watson
Bluegrass
Cape Town, South Africa

My humble photographic tribute to our world[^]

Nick Seng

I might have been exagerating a bit....It's just 2-4 tables that has 300+ fields, the rest have a more manageble fields of about 100 ;P Anyway, I'm the R&D department now, so I don't have to ever look at those database again!! :jig: ~life is good :)~ Notorious SMC

The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning Mark Twain
Get your facts first, and then you can distort them as much as you please Mark Twain

SimonS

The worse that I've seen is char 10's being used as a PK for no reason other than "we've always done it this way" and some rilly, rilly clever individual spending the day working out a practical use for his sort-by-guid stored procedure. Run, RUN! Cheers, Simon "The day I swan around in expensive suits is the day I hope someone puts a bullet in my head.", Chris Carter.
my svg article

Paul Watson

SimonS wrote: sort-by-guid stored procedure :laugh: :laugh: :laugh: Oh classic. A GUID sorter, hilarious :-D

Paul Watson
Bluegrass
Cape Town, South Africa

My humble photographic tribute to our world[^]

Richard Deeming

You think that's bad? Some of our customers use a product called Visma, which they need linked to their e-commerce site. As a typical example, the price table has 94 columns, most of which allow null, with wonderful names like "SDc2P", "Un", etc. Guess who gets the job of writing the interface? Nice photos, BTW. Planning a new career? :-D

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Paul Watson

Richard Deeming wrote: with wonderful names like "SDc2P", "Un", Un? LOL, ouch. My sympathies. Richard Deeming wrote: Nice photos, BTW. Planning a new career? :-O Thanks. I need to be a lot better before I can make it into a career though :)

Paul Watson
Bluegrass
Cape Town, South Africa

My humble photographic tribute to our world[^]

Roger Wright

Notorious SMC wrote: Mark Twain fan ? Absolutely!:-D His "The Innocents Abroad" provides some excellent examples of good reasons why the people of the middle East despise Americans. "How many times do I have to flush before you go away?" - Megan Forbes, on Management (12/5/2002)

Brian Delahunty

Paul Watson wrote: More like the life of the chap who made this table *dot, dot, dot* :laugh::laugh: Regards, Brian Dela :-)
Run naked in the snow until you're sweating like a stuck pig and can't seem to catch your breath. When the flu becomes pneumonia, they can cure that with a shot. - Roger Wright

Daniel Turini

Oh, I see it so often I put a recommendation about this in my article[^] I see dumb people