Tag Archives : backup compression

Optimizing Backup Performance

If your environment is anything like mine, backups are usually not allocated the speediest disk. Generally speaking, those disks are reserved for data, logs, and tempdb. So it’s up to us squeeze every last bit of performance out of our backup jobs.  If you’re using maintenance plans to do your backups, chances are you’re not […]

A little more about compression

Happy Monday folks!  Ready to talk some more about compression? Unicode Compression Another type of compression new in SQL Server 2008 is Unicode compression.  This is basically row compression for nchar and nvarchar datatypes.  Per BOL, SQL Server uses the Standard Compression Scheme for Unicode (SCSU) algorithm to achieve up to 50% space savings on […]