27

Just took a new role...

Production database filled with tables like the following :/

SELECT TOP (1000) [ID]
,[Field1]
,[Field2]
,[Field3]
,[Field4]
,[Field5]
,[Field6]
,[Field7]
,[Field8]
,[Field9]
,[Field10]
,[Field11]
,[Field12]
,[CapID]
,[Car_Manufacturer]
,[Car_Range]
,[Car_Derivative]
,[Field17]
,[Field18]
,[Field19]
,[Car_Model]
,[Field21]
,[Field22]
,[Field23]
FROM [****].[dbo].[****]

This isn't even the worst, there's a table with 250+ fields that should be broken out into 10-15 tables. The code is far, far worse.

Don't think I'll be here too long.

Comments
  • 1
    Wow! I feel the pain. Do you have any reference documentation for the tables?
  • 1
    Let the force be with you... or a shotgun..
    Either way I'm with you... for 5 minutes.... then I start to bleed from my eyes and have to run. 😖
  • 2
    Make the deaths less painful. May the Lord forgive you for your sins.
  • 2
    @DonQu
    I’ve asked it’s creator to produce documentation, but I’m still waiting...
  • 1
    @snap Haha. Like I said this doesn’t even touch the sides. Massive undocumented tables filled with stupid field names and duplicate data. Some of which are single char or numeric fields, so forget looking at the value for any insight on what the field is used for.

    Then there’s the APIs that consist of a single controller containing everything data access, business logic and all.

    I mean they (this is the work of two “developers”) can’t even create a model just a butt load of local variables. We’re talking 101.

    It’s just madness, never seen anything like it.
  • 1
    @A4Abhiraj

    I’m trying to retain myself, but something else will just appear shorting the fuse.
  • 1
    @delegate212 MVC without models? So, just VC then? Lol
  • 1
    Squirming until Field17 becomes Car_NoOfDoors.

    What a glorious day it will be.
  • 0
    @MrMeeseeks XD pretty much, yeah.
  • 0
    @delegate212 Ouch. Well it's going to take a while for you then!
  • 1
    I’ve started a new role time for me to get on Glassdoor and warn future developers of this ticking bomb.
Add Comment