Need to compress a giant table of 1.5TB in sql server 2008, which is the best option Page or row compression, please let me know the steps to do it.
SQL Server Table Compression – Row or Page?
sql server
Related Question
- Sql-server – SQL Server 2012 Page Compression – Determine compression ratio
- Sql-server – Should I add page level compression before adding the primary key, or after
- Sql-server – Page compression not working
- SQL Server Compression – Understanding Compression and Maximum Row Size
- SQL Server – Enabling Page Compression on 1.5TB Table
- Sql-server – After page compressing a huge table, the disk space didn’t change. Do I need to shrink in any kind
- Sql-server – Is compression used in RDS SQLServer database
- How to Check if Data in SQL Server Table is Page-Compressed
Best Answer
There is no such a thing as "best option". If
page
would always be superior, why bother offeringrow
as sub-par alternative or vice versa? It really depends on a lot of things, so further analysis is needed. Start by reading some materials about data compression. MS has published a technical article Data Compression: Strategy, Capacity Planning and Best Practices that's a bit old, but fits your Sql Server version.By the way, Sql Server 2008 has been out of mainstream support since Q2 2014 (and this is assuming you are running the latest SP4 patchlevel). You really should consider upgrading into more recent a version of Sql Server.