I'm working with a SQL server DB in SQL 2014.
The client has one table 'tblLandHistrory' containing historical data that is much larger than any of the other data tables in the DB and is not used frequently. The client also has disk space limitations and has asked to see how much space can be gained by compressing the DB.
I have always tried to avoid compressing SQL DB's because of the performance hit. I know it's usually not that great of a hit but I like to keep things as fast as possible.
I explained that to the client, then asked if it was possible to only compress the one massive table 'tblLandHistory'. I really don't know if it is possible to just compress one table in the DB. If so, this one would be an ideal candidate. It needs to be available but is used infrequently.
Is it possible to compress select (not the entire DB) tables in a SQL DB? If it is how is that accomplished?