data-konzept

'My SQL Server database has some very big tables that can be compressed. The tables are simple, non-partitioned tables and I want a quick tool to compress them. I do not want to shrink the whole database since it will apply a global lock on the whole database, including both the partitioned and non-partitioned objects. How can this task be achieved?'...

https://www.mssqltips.com/sqlservertip/4372/sql-server-stored-procedure-to-compress-non-partitioned-tables/