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,599 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
2,001 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,212 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,850 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,285 reads
2015-02-19 (first published: 2014-02-03)
1,793 reads
2014-01-30
1,973 reads
By Steve Jones
I have been experimenting a bit with graph databases, trying to learn more about...
By Steve Jones
Thanks to everyone who attended my talk at VS Live Las Vegas 2023 on...
By Steve Jones
I delivered my talk on Architecting Zero Downtime Deployments yesterday at VS Live Las...
Nấm lim xanh rừng nổi tiếng với những công dụng tuyệt vời đối với...
Comments posted to this topic are about the item How to Connect SQL Server...
Comments posted to this topic are about the item Adjusting DOP based on Feedback