Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
![](/static/devrant/img/pipeless-devrant-banner-white.png)
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
C0D4682467yI got as far as stored procedure creating customer specific tables.
I don’t even want to know what drugs that dev / dba was smoking when they thought that was a good idea.
Your only option is “DROP Database xyz” and walk away 🤮 -
C0D4682467y@lotd let’s hope that’s the case, but then who ever approved, or didn’t approve and let it go into the wild, as such an atrocity should have been shot
-
@C0D4 I'll tell you even worse: this was in prod and was created by a senior dev.
-
C0D4682467y@grumpylady01 that I would believe, it’s just surprising someone managed to think that was a good idea 😂
Unless you have extremely active customers creating billions of records I can’t imagine a reason to create tables like that, plus doesn’t MS have restrictions on the number of tables you can create? -
@C0D4 2.147 billion db objects to be exact (see: https://docs.microsoft.com/en-us/...).
Clearly, the senior dev who developed this doesn't have the experience to design a relational db. What's more annoying is that the senior dev was proud of doing this work. -
Whip that idiot's ass hard! Then pay his/her college fees to go back to school.
Discovered one of the worst db designs ever:
- A cust is inserted in a table.
- The insert trigger is fired, calling a stored proc
- The stored proc being called creates a dynamic sql that builds a create table statement for 8 different tables. These tables will be postfixed with the newly-created cust id and is executed.
When querying info for a cust, a stored proc is used that accepts an id value would be appended to another dynamic sql that creates a select statement across all 8 tables for one customer.
Shoot me now.
rant
sql relational-db mssql kill-me