Month: November 2008

SQL Server 2008 – Backup Compression

The biggest benefit that I see with the new backup compression in SQL Server 2008 is that it improves the speed of the restore. The thing that is far more important that a database backup is the actual restore process,

Posted in Steve

SQL Server 2008 – Sparse Columns

In SQL Server, an empty or a null column still would take up space in the database, so even if you added a column that was set to null values, there would still be space taken up in the database.

Posted in Steve Tagged with: