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 [...]
November 22, 2011
Tags: backup compression, backups, performance Posted in: Maintenance 
No Comments
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 [...]
May 23, 2011
Tags: backup compression, data compression, row compression, unicode compression Posted in: Features No Comments
