Naming conventions? We don't need no stinkin' naming conventions (or any convention or even common sense for that matter)!
-
Had to write some query on a SQL Server database today. Opening the database took close to a minute. What I saw then will forever haunt me. Table names like [01 Some Company & Partner l.l.c.$Customer Ledger item], but also [01 Some Company & Partner llc$Cust something else], because sometimes you need Customer while other times you simply need Cust. Each table had columns with names like [Entry No_], [Customer report code 1] and [Amount (CNY)] (CNY apparently means "currency", but with column names like that why even bother to abbreviate?) :sigh: So we've got names with spaces, dots, numbers and symbols, complex enough to pass a password complexity validation! Now there's something particularly odd about the table name... The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! :wtf: So let me say this again so you can be sure you read it right and I spelled it correctly... OVER FORTY-ONE THOUSAND TABLES! :wtf: It was a bit over 1700 tables per company, which I already think is A LOT, combined in a single database. SQL Server allows for int.MaxValue objects in a single database and I have a feeling this application was pushing the limit (if not, not for lack of trying) :laugh: I'm assuming most of it is generated, but even then, WHY WOULD YOU GENERATE SUCH !G($#&#$(!#F:elephant:J!#(P!? :mad: Sometimes you think you've seen it all and then you run into something like this and realize there really is no limit to human stupidity :sigh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
-
Had to write some query on a SQL Server database today. Opening the database took close to a minute. What I saw then will forever haunt me. Table names like [01 Some Company & Partner l.l.c.$Customer Ledger item], but also [01 Some Company & Partner llc$Cust something else], because sometimes you need Customer while other times you simply need Cust. Each table had columns with names like [Entry No_], [Customer report code 1] and [Amount (CNY)] (CNY apparently means "currency", but with column names like that why even bother to abbreviate?) :sigh: So we've got names with spaces, dots, numbers and symbols, complex enough to pass a password complexity validation! Now there's something particularly odd about the table name... The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! :wtf: So let me say this again so you can be sure you read it right and I spelled it correctly... OVER FORTY-ONE THOUSAND TABLES! :wtf: It was a bit over 1700 tables per company, which I already think is A LOT, combined in a single database. SQL Server allows for int.MaxValue objects in a single database and I have a feeling this application was pushing the limit (if not, not for lack of trying) :laugh: I'm assuming most of it is generated, but even then, WHY WOULD YOU GENERATE SUCH !G($#&#$(!#F:elephant:J!#(P!? :mad: Sometimes you think you've seen it all and then you run into something like this and realize there really is no limit to human stupidity :sigh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
Clearly, I'm going to die working. When I read stuff like this, the inmates are running the asylum.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
-
Had to write some query on a SQL Server database today. Opening the database took close to a minute. What I saw then will forever haunt me. Table names like [01 Some Company & Partner l.l.c.$Customer Ledger item], but also [01 Some Company & Partner llc$Cust something else], because sometimes you need Customer while other times you simply need Cust. Each table had columns with names like [Entry No_], [Customer report code 1] and [Amount (CNY)] (CNY apparently means "currency", but with column names like that why even bother to abbreviate?) :sigh: So we've got names with spaces, dots, numbers and symbols, complex enough to pass a password complexity validation! Now there's something particularly odd about the table name... The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! :wtf: So let me say this again so you can be sure you read it right and I spelled it correctly... OVER FORTY-ONE THOUSAND TABLES! :wtf: It was a bit over 1700 tables per company, which I already think is A LOT, combined in a single database. SQL Server allows for int.MaxValue objects in a single database and I have a feeling this application was pushing the limit (if not, not for lack of trying) :laugh: I'm assuming most of it is generated, but even then, WHY WOULD YOU GENERATE SUCH !G($#&#$(!#F:elephant:J!#(P!? :mad: Sometimes you think you've seen it all and then you run into something like this and realize there really is no limit to human stupidity :sigh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
I apologize. I was in a mood when I generated that. :laugh:
Real programmers use butterflies
-
I apologize. I was in a mood when I generated that. :laugh:
Real programmers use butterflies
honey the codewitch wrote:
I apologize. I was in a mood high when I generated that.
FTFY ;P :laugh:
M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.
-
Had to write some query on a SQL Server database today. Opening the database took close to a minute. What I saw then will forever haunt me. Table names like [01 Some Company & Partner l.l.c.$Customer Ledger item], but also [01 Some Company & Partner llc$Cust something else], because sometimes you need Customer while other times you simply need Cust. Each table had columns with names like [Entry No_], [Customer report code 1] and [Amount (CNY)] (CNY apparently means "currency", but with column names like that why even bother to abbreviate?) :sigh: So we've got names with spaces, dots, numbers and symbols, complex enough to pass a password complexity validation! Now there's something particularly odd about the table name... The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! :wtf: So let me say this again so you can be sure you read it right and I spelled it correctly... OVER FORTY-ONE THOUSAND TABLES! :wtf: It was a bit over 1700 tables per company, which I already think is A LOT, combined in a single database. SQL Server allows for int.MaxValue objects in a single database and I have a feeling this application was pushing the limit (if not, not for lack of trying) :laugh: I'm assuming most of it is generated, but even then, WHY WOULD YOU GENERATE SUCH !G($#&#$(!#F:elephant:J!#(P!? :mad: Sometimes you think you've seen it all and then you run into something like this and realize there really is no limit to human stupidity :sigh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
-
Had to write some query on a SQL Server database today. Opening the database took close to a minute. What I saw then will forever haunt me. Table names like [01 Some Company & Partner l.l.c.$Customer Ledger item], but also [01 Some Company & Partner llc$Cust something else], because sometimes you need Customer while other times you simply need Cust. Each table had columns with names like [Entry No_], [Customer report code 1] and [Amount (CNY)] (CNY apparently means "currency", but with column names like that why even bother to abbreviate?) :sigh: So we've got names with spaces, dots, numbers and symbols, complex enough to pass a password complexity validation! Now there's something particularly odd about the table name... The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! :wtf: So let me say this again so you can be sure you read it right and I spelled it correctly... OVER FORTY-ONE THOUSAND TABLES! :wtf: It was a bit over 1700 tables per company, which I already think is A LOT, combined in a single database. SQL Server allows for int.MaxValue objects in a single database and I have a feeling this application was pushing the limit (if not, not for lack of trying) :laugh: I'm assuming most of it is generated, but even then, WHY WOULD YOU GENERATE SUCH !G($#&#$(!#F:elephant:J!#(P!? :mad: Sometimes you think you've seen it all and then you run into something like this and realize there really is no limit to human stupidity :sigh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
I'm afraid I have been there, just not with so many tables (maybe 20) nor companies (only 3), and using MySQL. I just made a "SQL template" script and separated the companies into separate databases. Any common change would be made to the template and would be inherited by all (when the script was run against each of the databases). But I guess they have to justify buying new hardware when their queries are not fast enough. Hey, at least those have their queries in the database, right? Right?! In my case they were doing all queries (even simple ones like "select * from tableA where userID=x") in a weird PHP backend because they claimed that "the database is not good enough to filter the tables the way we want it" :wtf: Anyway, I think some whipping is in order. Grab your whip and get the guy that wrote that database. Don't let him procreate more databases like that :mad: :-D
-
Had to write some query on a SQL Server database today. Opening the database took close to a minute. What I saw then will forever haunt me. Table names like [01 Some Company & Partner l.l.c.$Customer Ledger item], but also [01 Some Company & Partner llc$Cust something else], because sometimes you need Customer while other times you simply need Cust. Each table had columns with names like [Entry No_], [Customer report code 1] and [Amount (CNY)] (CNY apparently means "currency", but with column names like that why even bother to abbreviate?) :sigh: So we've got names with spaces, dots, numbers and symbols, complex enough to pass a password complexity validation! Now there's something particularly odd about the table name... The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! :wtf: So let me say this again so you can be sure you read it right and I spelled it correctly... OVER FORTY-ONE THOUSAND TABLES! :wtf: It was a bit over 1700 tables per company, which I already think is A LOT, combined in a single database. SQL Server allows for int.MaxValue objects in a single database and I have a feeling this application was pushing the limit (if not, not for lack of trying) :laugh: I'm assuming most of it is generated, but even then, WHY WOULD YOU GENERATE SUCH !G($#&#$(!#F:elephant:J!#(P!? :mad: Sometimes you think you've seen it all and then you run into something like this and realize there really is no limit to human stupidity :sigh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
Never used SQL but :laugh: Could CNY be Chinese Yuan? It's the standard forex abbreviation for it.
Robust Services Core | Software Techniques for Lemmings | Articles
The fox knows many things, but the hedgehog knows one big thing. -
Had to write some query on a SQL Server database today. Opening the database took close to a minute. What I saw then will forever haunt me. Table names like [01 Some Company & Partner l.l.c.$Customer Ledger item], but also [01 Some Company & Partner llc$Cust something else], because sometimes you need Customer while other times you simply need Cust. Each table had columns with names like [Entry No_], [Customer report code 1] and [Amount (CNY)] (CNY apparently means "currency", but with column names like that why even bother to abbreviate?) :sigh: So we've got names with spaces, dots, numbers and symbols, complex enough to pass a password complexity validation! Now there's something particularly odd about the table name... The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! :wtf: So let me say this again so you can be sure you read it right and I spelled it correctly... OVER FORTY-ONE THOUSAND TABLES! :wtf: It was a bit over 1700 tables per company, which I already think is A LOT, combined in a single database. SQL Server allows for int.MaxValue objects in a single database and I have a feeling this application was pushing the limit (if not, not for lack of trying) :laugh: I'm assuming most of it is generated, but even then, WHY WOULD YOU GENERATE SUCH !G($#&#$(!#F:elephant:J!#(P!? :mad: Sometimes you think you've seen it all and then you run into something like this and realize there really is no limit to human stupidity :sigh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
And I'll bet some company tables are unique so combining them will be a challenge. I made a tidy living in the 90's attempting to normalise such horrors, never quite that big and ugly though. I wonder if the original was converted from MS Access, it is definitely an end user built database. So quote a rate and don't offer a time frame (or even a guarantee) if you are going to try and clean it up. PS CNY is definitely the Chinese currency.
Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP
-
Had to write some query on a SQL Server database today. Opening the database took close to a minute. What I saw then will forever haunt me. Table names like [01 Some Company & Partner l.l.c.$Customer Ledger item], but also [01 Some Company & Partner llc$Cust something else], because sometimes you need Customer while other times you simply need Cust. Each table had columns with names like [Entry No_], [Customer report code 1] and [Amount (CNY)] (CNY apparently means "currency", but with column names like that why even bother to abbreviate?) :sigh: So we've got names with spaces, dots, numbers and symbols, complex enough to pass a password complexity validation! Now there's something particularly odd about the table name... The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! :wtf: So let me say this again so you can be sure you read it right and I spelled it correctly... OVER FORTY-ONE THOUSAND TABLES! :wtf: It was a bit over 1700 tables per company, which I already think is A LOT, combined in a single database. SQL Server allows for int.MaxValue objects in a single database and I have a feeling this application was pushing the limit (if not, not for lack of trying) :laugh: I'm assuming most of it is generated, but even then, WHY WOULD YOU GENERATE SUCH !G($#&#$(!#F:elephant:J!#(P!? :mad: Sometimes you think you've seen it all and then you run into something like this and realize there really is no limit to human stupidity :sigh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
this madness looks like it could make you indispensable if you raise to the challenge! :laugh:
A new .NET Serializer All in one Menu-Ribbon Bar Taking over the world since 1371!
-
Had to write some query on a SQL Server database today. Opening the database took close to a minute. What I saw then will forever haunt me. Table names like [01 Some Company & Partner l.l.c.$Customer Ledger item], but also [01 Some Company & Partner llc$Cust something else], because sometimes you need Customer while other times you simply need Cust. Each table had columns with names like [Entry No_], [Customer report code 1] and [Amount (CNY)] (CNY apparently means "currency", but with column names like that why even bother to abbreviate?) :sigh: So we've got names with spaces, dots, numbers and symbols, complex enough to pass a password complexity validation! Now there's something particularly odd about the table name... The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! :wtf: So let me say this again so you can be sure you read it right and I spelled it correctly... OVER FORTY-ONE THOUSAND TABLES! :wtf: It was a bit over 1700 tables per company, which I already think is A LOT, combined in a single database. SQL Server allows for int.MaxValue objects in a single database and I have a feeling this application was pushing the limit (if not, not for lack of trying) :laugh: I'm assuming most of it is generated, but even then, WHY WOULD YOU GENERATE SUCH !G($#&#$(!#F:elephant:J!#(P!? :mad: Sometimes you think you've seen it all and then you run into something like this and realize there really is no limit to human stupidity :sigh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
The only difference between a mad man and a genius is that a genius knows that there is an int.MaxValue limit. :laugh:
-
Had to write some query on a SQL Server database today. Opening the database took close to a minute. What I saw then will forever haunt me. Table names like [01 Some Company & Partner l.l.c.$Customer Ledger item], but also [01 Some Company & Partner llc$Cust something else], because sometimes you need Customer while other times you simply need Cust. Each table had columns with names like [Entry No_], [Customer report code 1] and [Amount (CNY)] (CNY apparently means "currency", but with column names like that why even bother to abbreviate?) :sigh: So we've got names with spaces, dots, numbers and symbols, complex enough to pass a password complexity validation! Now there's something particularly odd about the table name... The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! :wtf: So let me say this again so you can be sure you read it right and I spelled it correctly... OVER FORTY-ONE THOUSAND TABLES! :wtf: It was a bit over 1700 tables per company, which I already think is A LOT, combined in a single database. SQL Server allows for int.MaxValue objects in a single database and I have a feeling this application was pushing the limit (if not, not for lack of trying) :laugh: I'm assuming most of it is generated, but even then, WHY WOULD YOU GENERATE SUCH !G($#&#$(!#F:elephant:J!#(P!? :mad: Sometimes you think you've seen it all and then you run into something like this and realize there really is no limit to human stupidity :sigh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
I once got to look into the table and variable name structure of BPCS. It, too, was a nightmare, and I can't believe it was a successful commercial venture. It might not have been as bad as the one you looked at. I don't know, because I cussed and closed it as soon as I could! :laugh:
The Science of King David's Court | Object Oriented Programming with C++
-
Had to write some query on a SQL Server database today. Opening the database took close to a minute. What I saw then will forever haunt me. Table names like [01 Some Company & Partner l.l.c.$Customer Ledger item], but also [01 Some Company & Partner llc$Cust something else], because sometimes you need Customer while other times you simply need Cust. Each table had columns with names like [Entry No_], [Customer report code 1] and [Amount (CNY)] (CNY apparently means "currency", but with column names like that why even bother to abbreviate?) :sigh: So we've got names with spaces, dots, numbers and symbols, complex enough to pass a password complexity validation! Now there's something particularly odd about the table name... The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! :wtf: So let me say this again so you can be sure you read it right and I spelled it correctly... OVER FORTY-ONE THOUSAND TABLES! :wtf: It was a bit over 1700 tables per company, which I already think is A LOT, combined in a single database. SQL Server allows for int.MaxValue objects in a single database and I have a feeling this application was pushing the limit (if not, not for lack of trying) :laugh: I'm assuming most of it is generated, but even then, WHY WOULD YOU GENERATE SUCH !G($#&#$(!#F:elephant:J!#(P!? :mad: Sometimes you think you've seen it all and then you run into something like this and realize there really is no limit to human stupidity :sigh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
Sander Rossel wrote:
OVER FORTY-ONE THOUSAND TABLES!
Wilco. Tango. Foxtrot. Echo. :wtf: :omg: X|
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows. -- 6079 Smith W.
-
I'm afraid I have been there, just not with so many tables (maybe 20) nor companies (only 3), and using MySQL. I just made a "SQL template" script and separated the companies into separate databases. Any common change would be made to the template and would be inherited by all (when the script was run against each of the databases). But I guess they have to justify buying new hardware when their queries are not fast enough. Hey, at least those have their queries in the database, right? Right?! In my case they were doing all queries (even simple ones like "select * from tableA where userID=x") in a weird PHP backend because they claimed that "the database is not good enough to filter the tables the way we want it" :wtf: Anyway, I think some whipping is in order. Grab your whip and get the guy that wrote that database. Don't let him procreate more databases like that :mad: :-D
ElectronProgrammer wrote:
Grab your whip and get the guy that wrote that database. Don't let him procreate more databases like that
FTFY
Wrong is evil and must be defeated. - Jeff Ello
-
Had to write some query on a SQL Server database today. Opening the database took close to a minute. What I saw then will forever haunt me. Table names like [01 Some Company & Partner l.l.c.$Customer Ledger item], but also [01 Some Company & Partner llc$Cust something else], because sometimes you need Customer while other times you simply need Cust. Each table had columns with names like [Entry No_], [Customer report code 1] and [Amount (CNY)] (CNY apparently means "currency", but with column names like that why even bother to abbreviate?) :sigh: So we've got names with spaces, dots, numbers and symbols, complex enough to pass a password complexity validation! Now there's something particularly odd about the table name... The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! :wtf: So let me say this again so you can be sure you read it right and I spelled it correctly... OVER FORTY-ONE THOUSAND TABLES! :wtf: It was a bit over 1700 tables per company, which I already think is A LOT, combined in a single database. SQL Server allows for int.MaxValue objects in a single database and I have a feeling this application was pushing the limit (if not, not for lack of trying) :laugh: I'm assuming most of it is generated, but even then, WHY WOULD YOU GENERATE SUCH !G($#&#$(!#F:elephant:J!#(P!? :mad: Sometimes you think you've seen it all and then you run into something like this and realize there really is no limit to human stupidity :sigh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
whenever i'm on a project and see a mismatch in the names in the database, the back-end and the front-end i immediately get the urge to kill everyone. > The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! that's like creating 150+ tables a day for an entire year. part of those tables are created dynamically? abandon project
-
Had to write some query on a SQL Server database today. Opening the database took close to a minute. What I saw then will forever haunt me. Table names like [01 Some Company & Partner l.l.c.$Customer Ledger item], but also [01 Some Company & Partner llc$Cust something else], because sometimes you need Customer while other times you simply need Cust. Each table had columns with names like [Entry No_], [Customer report code 1] and [Amount (CNY)] (CNY apparently means "currency", but with column names like that why even bother to abbreviate?) :sigh: So we've got names with spaces, dots, numbers and symbols, complex enough to pass a password complexity validation! Now there's something particularly odd about the table name... The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! :wtf: So let me say this again so you can be sure you read it right and I spelled it correctly... OVER FORTY-ONE THOUSAND TABLES! :wtf: It was a bit over 1700 tables per company, which I already think is A LOT, combined in a single database. SQL Server allows for int.MaxValue objects in a single database and I have a feeling this application was pushing the limit (if not, not for lack of trying) :laugh: I'm assuming most of it is generated, but even then, WHY WOULD YOU GENERATE SUCH !G($#&#$(!#F:elephant:J!#(P!? :mad: Sometimes you think you've seen it all and then you run into something like this and realize there really is no limit to human stupidity :sigh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
Be thankful... it could have been access... or even better, excel tables :laugh: :laugh:
M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.
-
Had to write some query on a SQL Server database today. Opening the database took close to a minute. What I saw then will forever haunt me. Table names like [01 Some Company & Partner l.l.c.$Customer Ledger item], but also [01 Some Company & Partner llc$Cust something else], because sometimes you need Customer while other times you simply need Cust. Each table had columns with names like [Entry No_], [Customer report code 1] and [Amount (CNY)] (CNY apparently means "currency", but with column names like that why even bother to abbreviate?) :sigh: So we've got names with spaces, dots, numbers and symbols, complex enough to pass a password complexity validation! Now there's something particularly odd about the table name... The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! :wtf: So let me say this again so you can be sure you read it right and I spelled it correctly... OVER FORTY-ONE THOUSAND TABLES! :wtf: It was a bit over 1700 tables per company, which I already think is A LOT, combined in a single database. SQL Server allows for int.MaxValue objects in a single database and I have a feeling this application was pushing the limit (if not, not for lack of trying) :laugh: I'm assuming most of it is generated, but even then, WHY WOULD YOU GENERATE SUCH !G($#&#$(!#F:elephant:J!#(P!? :mad: Sometimes you think you've seen it all and then you run into something like this and realize there really is no limit to human stupidity :sigh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
What can I say? I was young, and I needed the money... :rolleyes:
Anything that is unrelated to elephants is irrelephant
Anonymous
-----
The problem with quotes on the internet is that you can never tell if they're genuine
Winston Churchill, 1944
-----
Never argue with a fool. Onlookers may not be able to tell the difference.
Mark Twain -
whenever i'm on a project and see a mismatch in the names in the database, the back-end and the front-end i immediately get the urge to kill everyone. > The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! that's like creating 150+ tables a day for an entire year. part of those tables are created dynamically? abandon project
Martin ISDN wrote:
that's like creating 150+ tables a day for an entire year. part of those tables are created dynamically?
I think it's the product of years of development and dynamic table creation, possibly created by a user directly from the product. But I'm not sure.
Martin ISDN wrote:
abandon project
Because I don't like a database I have to access once? Would be very bad for my finances :rolleyes:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
-
I once got to look into the table and variable name structure of BPCS. It, too, was a nightmare, and I can't believe it was a successful commercial venture. It might not have been as bad as the one you looked at. I don't know, because I cussed and closed it as soon as I could! :laugh:
The Science of King David's Court | Object Oriented Programming with C++
David O'Neil wrote:
and I can't believe it was a successful commercial venture
I always wonder about that too. Not because the database is a mess, because users can't care less about that, but because if the database is a mess then it's likely that everything else is a mess too. Maybe it's just this weird naming that's wrong with it, maybe the naming was generated by some tool, but the developers actually know what they're doing? :confused:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
-
this madness looks like it could make you indispensable if you raise to the challenge! :laugh:
A new .NET Serializer All in one Menu-Ribbon Bar Taking over the world since 1371!
No challenges here. Another company owns the database, someone else sometimes works with it. That someone else asked me if I could do him a favor and write that query. Other than that the database is not used anymore and kept around for historical data. I've got other (fun) challenges coming my way :D
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
-
Had to write some query on a SQL Server database today. Opening the database took close to a minute. What I saw then will forever haunt me. Table names like [01 Some Company & Partner l.l.c.$Customer Ledger item], but also [01 Some Company & Partner llc$Cust something else], because sometimes you need Customer while other times you simply need Cust. Each table had columns with names like [Entry No_], [Customer report code 1] and [Amount (CNY)] (CNY apparently means "currency", but with column names like that why even bother to abbreviate?) :sigh: So we've got names with spaces, dots, numbers and symbols, complex enough to pass a password complexity validation! Now there's something particularly odd about the table name... The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! :wtf: So let me say this again so you can be sure you read it right and I spelled it correctly... OVER FORTY-ONE THOUSAND TABLES! :wtf: It was a bit over 1700 tables per company, which I already think is A LOT, combined in a single database. SQL Server allows for int.MaxValue objects in a single database and I have a feeling this application was pushing the limit (if not, not for lack of trying) :laugh: I'm assuming most of it is generated, but even then, WHY WOULD YOU GENERATE SUCH !G($#&#$(!#F:elephant:J!#(P!? :mad: Sometimes you think you've seen it all and then you run into something like this and realize there really is no limit to human stupidity :sigh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables!
Probably not intended, but this sounds like a great way to be GPDR compliant - each table can have different access controls so that someone who is allowed to view the data for $COMPANY_A will never be allowed to view the data for $COMPANY_B. Unintended consequences, and all that...
