<div>
Thanks to all for your insight
</div>


<div>
<div class="content wysiwyg-content">
I am a NUB to SQL Server, developing an Access 2013 back end DB in SQL 14.0 Developer.<br />
<br />
I see that it is very easy to implement compression on both tables and indexes to reduce the size of the stored data.<br />
<br />
In general I have always stayed away from compression because it adds more overhead in data, creation, retrieval and update.<br />
<br />
My uncompressed DB size is about 100GB and we have ample disk space available to store it. &nbsp;I've gone thru the compression analyzer for some of the larger tables and can see that disk requirements would be reduced by almost 65%.<br />
<br />
The question: <br />
Given that we have ample disk space is there any benefit to implementing compression? &nbsp;If there is not a general rule about &nbsp;benefit or drawbacks to using compression, what kind of criterion are used to make the decision on a table by table or even index by index level?
</div>
</div>


I am a NUB to SQL Server, developing an Access 2013 back end DB in SQL 14.0 Developer.

I see that it is very easy to implement compression on both tables and indexes to reduce the size of the stored data.

In general I have always stayed away from compression because it adds more overhead in data, creation, retrieval and update.

My uncompressed DB size is about 100GB and we have ample disk space available to store it.  I've gone thru the compression analyzer for some of the larger tables and can see that disk requirements would be reduced by almost 65%.

The question: 
Given that we have ample disk space is there any benefit to implementing compression?  If there is not a general rule about  benefit or drawbacks to using compression, what kind of criterion are used to make the decision on a table by table or even index by index level?

SQL Server Compression Decision

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.