6
lorentz
18h

How is MSSQL so popular? "Oh yeah, sometimes you have to use dynamic SQL because the compiler doesn't correctly detect the impact of DDL commands and rejects working code" god fucking what? Why does the compiler infer the future structure of tables after a DDL command if it can't do so reliably? In my world, if it becomes public knowledge that a compiler incorrectly infers something, the maintainer scrambles to remove the inference instead.

I also find it surreal that I have to disengage versioning on a table in order to be able to modify the version history. Like surely, there should be a mechanism to temporarily skip the hooks other than ALTERing the table into a regular unversioned database table and then ALTERing it back, rebuilding the versioning infrastructure from scratch. SQL is awful and MSSQL is doubly awful.

Comments
  • 2
    The reason why any MS product is or was popular. They use their company power.
  • 2
    @Lensflare Supposedly, they actually went around advertising MSSQL to executives when they first got into the DB business to get it off the ground. The fact that an executive listens to an external salesman for anything other than management tools is insane.
  • 3
    > "How is MSSQL so popular?"

    #1, its from Microsoft (nobody ever gets fired when choosing a product from Microsoft)

    #2, its not Oracle

    #3, Bill's nearsighted grandma with dementia can create a table with as much skill as MS Certified DBA.

    I've been using MSSQL since 6.5 and like any legacy 'enterprise' product, its become so bloated with nonsense nobody but niche edge cases every use its 'enterprise' features.
  • 1
    I like the syntax
    The monitoring tools were nice too
Add Comment