Another compression feature, called Sparse Columns, allows you to store nulls without taking up physical space. Sparse Columns will come in handy for large tables containing many null values.

Not only does SQL Server spare you from creating an additional copy of the data, but you can still perform operations on the table during the compression operation, no downtime required.

Technical documentation for Microsoft SQL Server, tools such as SQL Server Management Studio (SSMS) , SQL Server Data Tools (SSDT) etc. - MicrosoftDocs/sql-docs ...

A topic that has stirred up the SQL Server community as of late has been data compression. SQL Server 2008 gives us the ability to compress data and save on disk space.

Contribute to RAJ-SQLSERVER/nate-hughes-dba-scripts development by creating an account on GitHub.

The good news is, once compression is enabled on a table, all the intelligence is handled by SQL Server, your application code does not have to change and you may see immediate space savings with ...

Another compression feature, called Sparse Columns, allows you to store nulls without taking up physical space. Sparse Columns will come in handy for large tables containing many null values.

In-Depth SQL Server 2008 Is Finally Here. Now What? Microsoft's latest relational database management system contains a host of new features, but are they enough to make you migrate? By Eric ...