A quick introduction to SPARSE Columns in SQL Server 2008, which take almost no space for NULL and zero values. Learn the basics and the 100,000 column limit.
SQL SERVER – Find Space Used For Any Particular Table
Running out of drive space is a common reason SQL Server stops. sp_spaceused shows the Space Used by any table, with its row count and index size.
SQL SERVER – 2008 – Introduction to Row Compression
Row Compression in SQL Server 2008 stores zero and null values without using disk space. Check the savings first with sp_estimate_data_compression_savings.
SQL SERVER – 2008 – Introduction to New Feature of Backup Compression
SQL Server 2008 adds Backup Compression. I back up AdventureWorks with and without compression, compare file sizes and show how to turn it on at server level.
SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf) – Part 2
A last resort for corrupt datafiles with no backup: emergency mode, single user, then DBCC CHECKDB with repair_allow_data_loss. Back up the files first.
SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf)
Can you restore database using corrupt datafiles when there is no full backup and both .mdf and .ldf are damaged? My honest answer and the one thing to try.
SQL SERVER – 2005 – Database Table Partitioning Tutorial – How to Horizontal Partition Database Table
A simple Table Partitioning tutorial for SQL Server 2005 that shows, step by step, how to horizontally partition a database table across two filegroups.