Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Fabien Deshayes discusses the strategies ...

This script automates the page compression of tables across the top 10 largest online databases in your SQL Server instance. It includes elapsed time tracking for each database and table, providing ...

Backup Compression is also new in SQL Server 2008. Although the compression itself works well, the feature has too many limitations (including supporting only Enterprise Edition) to be effective in an ...

A CLR UDT has a limit of 8000 bytes - I doubt thats big enough to pack a file into. I guess you could use custom serialization and store the compressed file in a different table using the ...