Does SQL Server 2008 compress the results sent back to my web server?
- by Jeff Meatball Yang
I have a typical reporting application:
Large report <-- HTTP Compression --> ASP.NET Web Server <-- ??? --> SQL Server 2008
Since I have so much (repetitive) data to send to the client, I would like both network hops to have compression.
Is there a transport-level compression setting for SQL Server?