November 2008

SQL Server 2008 – Backup Compression

by SteveStedman
November 15, 2008March 7, 2012
Steve

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… Read More »SQL Server 2008 – Backup Compression

SQL Server 2008 – Sparse Columns

by SteveStedman
November 7, 2008March 7, 2012
Steve

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… Read More »SQL Server 2008 – Sparse Columns