Earlier I wrote a blog post about how Data Compression for Performance can help improve the efficiency of SQL Server.
SQL SERVER – Script to Estimate Compression
I had implemented Data Compression at my client Performance Health Check. Let us discuss how we can estimate compression.
SQL SERVER – Data and Index Compression – Real-World Conversation
Today we are going to see a real-world conversation about Data and Index Compression in SQL Server. I recently discussed this with my client.
SQL SERVER – Script to Enable PAGE and ROW Level Compression – Disable Compression
Comprehensive Database Performance Health Check Client sent me an SOS message for help . The entire issue was about Page and Row level compression.
Where is the Default Settings for Backup Compression? – Interview Question of the Week #191
Question: Where is the Default Settings for Backup Compression?
How to Estimate Space Saved by Data Compression in SQL Server? – Interview Question of the Week #167
Question: How to Estimate Space Saved by Data Compression in SQL Server?