Is there a way to create a SQL Server 2014 database so that all data tables will be compressed automatically?
Is there a way to compress all the existing tables of a SQL Server 2014 database?
Background: we run a data-gathering program that writes several multi-million row tables into a database which is then copied to a separate computer for offline analysis and reporting, often in a different physical location. The separate computer is not as powerful as the data-gathering computer, and has limited disk space, so the database size is an issue.
Edit: We use SQL Server 2014 Enterprise. Each table has a primary key and two additional indexes.