We are using SQL Server Express 2019 and have inevitably ran into the 15GB cap. I now have to figure out a way to quickly compress data since we cannot buy a license at the moment.
At the moment it is only one table (more specifically one column in A table) that is holding 9GB of data. This data is basically a history of production information that is queried by a C# program to generate PDF's and various other things. The data type of the column is NVARCHAR(MAX).
I mainly have to main concerns.
What are the implications if I compress old data in this column? Will our application still get the uncompressed data when it is queried?
What is the best way to go about compressing a column holding 9GB of NVARCHAR(MAX) data, and still being able to query this historical data with the same SQL queries so that the entire codebase's calls don't have to be re-written?
Aby help would be greatly appreciated. Kind regards