TDS doesn't have built-in compression support. Here's my attempt at coercing SQL Server to return compressed result sets.

Optimizing a table for analytics and maintenance proved trickier than I expected.

Jump into the wayback machine and see what Dave was up to in 2023.