Hacker News new | ask | show | jobs
by p2detar 542 days ago
Not sure what your exact use case is, I'm curious actually, but storing JSON strings should work much better. JSON functions are supported since SQL Server 2016 [0]. This is how I do it atm. I store only indexible content in table columns and everything else goes into an `attributes` JSON column. MSSQL supports indexes even on JSON fields, but I have not tried that, yet.

0 - https://learn.microsoft.com/en-us/sql/relational-databases/j...