Compression

Learn about compression in SQL Server to reduce space needed to store data using Page, Columnstore, and Archive compression options.

In this tip we look at how to use WinRAR to backup and compress a SQL Server database backup and write to multiple smaller files.

In this tip we look at how you can use SQL Server compression to save storage space for specific tables as well as how to decompress when the data is queried.

Check out this script to see how backup compression can reduce the size of your backups.

This tip introduces the new built-in COMPRESS and DECOMPRESS functions in SQL Server 2016.

Learn about the new DECOMPRESS function in SQL Server. We will walk through examples of how to use this using PowerShell cmdlets.

Check out this SQL Server stored procedure to compress non partitioned tables to save significant storage in your SQL Server database.

Learn how to use the new SQL Server COMPRESS function to compress images using Azure and PowerShell.

In SQL Server 2016 we have new compression functions to compress and uncompress specific data. Read this tip to learn about these new functions.

For some projects, we may disable a database from growing and archive data out of it after a set point (often measured in time, though this may vary depending on data). With these databases, I've seen some clients use compression for tables and indexes as

You are a DBA or developer mulling over data compression options in SQL Server. You wish to know how much space compressing a particular index will save; you need to know how this will affect query performance. In this tip we compare the impact of compres

What are the differences in space consumption for the SQL Server partitioned index compression options? What compression options are available in SQL Server? Check out this tip to learn more.

SQL Server 2008 and later offers the ability to create compressed backup files. When creating the compressed backup, how much space is really needed and when does the space get allocated for the backup file? In this tip we take a look at how compressed

In SQL Server 2008, we were introduced to Data Compression which can reduce data storage needs and potentially improve overall data access in the Enterprise and Developer editions. I have heard there are two types of compression available. Can you pleas

Databases are getting bigger. You might argue that hard disks are getting bigger also; however (and putting Solid State Drives out of the equation for the moment) they are not getting faster. In fact most systems today, even those on big expensive SANs an

SQL Server 2008 introduced data compression and backup compression. In this tip we look at the impact of data compression when used with backup compression.

With SQL 2008 you have the ability to compress your database backups saving disk space but more importantly saving time.

Reducing the amount of storage that SQL Server uses is not as high of a priority as it used to be, but when tables grow to millions of rows a few bytes per row can have significant effect. For very large databases the storage issue gets more critical for

In this article we look at how to get estimates for space savings when using data compression.

As we are looking through the new features in SQL Server 2008 we found a potentially interesting one called Data Compression which we can use to reduce the size of tables, indexes or a subset of their partitions. Can you give us a detailed explanation of

Database backups and maintenance windows for very large database are very frustrating especially if we need to generate full database backups to initialize a database mirroring or transaction log shipping session. As we are looking through the new feature

Learn about how SQL Server data compression and backup compression can be used and save space.