Nice SQL Table, nice kitty
-
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 AfricaPaul 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
-
:omg: Fill me with your knowledge, your wisdom, your coffee.
-
David Wulff wrote: Seriously reconsidering the meaning of life? More like the life of the chap who made this table *dot, dot, dot* :laugh:
Paul Watson
Bluegrass
Cape Town, South Africa -
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
-
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 -
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 TwainAnd here I was thinking that one of our tables that contains 70 columns is impressively bad.
-
And here I was thinking that one of our tables that contains 70 columns is impressively bad.
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 -
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 TwainNotorious 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)
-
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)
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 -
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 TwainNotorious 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 -
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 AfricaI 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 -
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 -
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 articleSimonS wrote: sort-by-guid stored procedure :laugh: :laugh: :laugh: Oh classic. A GUID sorter, hilarious :-D
Paul Watson
Bluegrass
Cape Town, South Africa -
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
-
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
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 -
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 TwainNotorious 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)
-
David Wulff wrote: Seriously reconsidering the meaning of life? More like the life of the chap who made this table *dot, dot, dot* :laugh:
Paul Watson
Bluegrass
Cape Town, South AfricaPaul 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 -
Oh, I see it so often I put a recommendation about this in my article[^] I see dumb people
