I have a very large table with 1 billion rows
One of the columns stores full address details (street, town, city, country)
Previously it was varchar(max) but since we moved to multilingual we have to change it to nvarchar(max) which doubles the size
Our database size is now growing by 10.5GB a day and I'm looking at ways to reduce this
Is there a way to compress this data and uncompress on the web app?
Open to ideas and suggestions
SQL Server 2017 enterprise