Monthly Archives: 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:

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at SteveStedman.com with my newsletter.
Newsletter signup form.

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA