How to Estimate Space Saved by Data Compression in SQL Server? – Interview Question of the Week #167

Question: How to Estimate Space Saved by Data Compression in SQL Server?

Answer: It has been long since I have heard this question. I remember I used to answer this question pretty much every day when I was drivers were costly. Nowadays when the storage is very cheap (economical), this question is not something I hear every day. Anyway, let us quickly see the answer to this question.

How to Estimate Space Saved by Data Compression in SQL Server? - Interview Question of the Week #167 datacompression

There is already inbuilt stored procedure sp_estimate_data_compression_savings in SQL Server. We can pass…

Read the entire article at the source link… Pinal Dave

#codango #developer #development #coder #coding

We're happy to share this resource that we found. The content displayed on this page is property of it's original author and/or their organization.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*