Compressed Microsoft SQL Server Backups by Default
Learn how to create default database compression for your SQL Server databases.
2019-04-30
Learn how to create default database compression for your SQL Server databases.
2019-04-30
The script estimate compression benefits per each object in the database for which the page compression has not been implemented.
2018-02-15 (first published: 2018-01-15)
1,470 reads
This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.
2017-03-23
1,840 reads
Erin Stellato takes a look at the new COMPRESS and DECOMPRESS functions, comparing their impact on space and performance to traditional data compression.
2017-02-15
6,456 reads
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
2016-08-12
2,979 reads
Sharing our experience using Data Compression as a space savings option in MS SQL Server 2008
2018-10-19 (first published: 2016-01-18)
4,166 reads
This will log output of estimate compression for both PAGE and ROW for all tables and indexes
2015-12-10 (first published: 2015-11-20)
1,688 reads
This script is used to compress tables and indexes. It is designed for page compression on all. Just a little ditty to help with our EDW storage and processing.
2015-11-11 (first published: 2015-10-09)
1,269 reads
2015-02-19 (first published: 2014-02-03)
1,782 reads
2014-01-30
1,973 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Zikato
Foreword A picture is worth a thousand words. I use screenshots daily, whether it’s to...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Comments posted to this topic are about the item SQL Standard Confusion
Comments posted to this topic are about the item SQL Standard Confusion
I am trying to create a list type report and can't seem to get...