CODEWITHSUNDEEP
sql-server
zhongxiao37
zhongxiao37

Reputation: 987

Will data compression produce less transaction logs?

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

Answers (1)

steoleary
steoleary

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

Related Questions