Reputation: 987
The data compression is now available on SQL SERVER 2008 and later. So, it will compress the data size, also the storage for this server. I wonder if it will produce less transaction logs by same operations if the table is compressed.
Upvotes: 0
Views: 527
Reputation: 9298
The data held in the transaction log for transactions performed against compressed tables will use ROW compression (doesn't matter if you use ROW or PAGE in the table)
See the "What Happens to the Supporting Data Structures" section of the following page for reference:
Data Compression: Strategy, Capacity Planning and Best Practices
Upvotes: 1