SQL Server supports two types of data compression: row compression and page compression. Row compression eliminates unused space within a row and stores fixed-length data types as variable-length ...

Compression best practices are guidelines and recommendations that you can follow to apply either row-level or page-level compression to your SQL Server databases in a proper and efficient way.

However, one customer, ServiceU, estimated it would save between $25-$50K in its first year using SQL Server 2008 Data Compression. Now, that news will even make Ebeneezer Scrooge happy.

Backup Compression with SQL Server 2008. No need to turn to third-party tools to keep your databases as small as possible. It's in SQL Server 2008 now. ... You can change the default compression ...

FlashVols are volumes that are pinned in SSD so applications run at maximum performance without the potential delay due to caching algorithms or tiering policies. Combined with Tegile's de-duplication ...

In the world of SQL Server management, page-level corruption is an issue that can strike fear into the hearts of even the most experienced database administrators. When an 8 KB unit of data storage, ...