Compress SQL Server 2005 query results?

Is it possible to reduce network load by compressing sql query results in a transparent way for the client?
DB engine : SQL Server 2005

  • Low performance with linq and INTERSECT/EXCEPT in small collections
  • A SQL Query to select two substrings from a known string
  • Finally Clause in SQL Server Transaction? Something that will execute irrespective of success or failure?
  • SSRS report objects rendering
  • Formatting dates with SQL Report Server
  • SQL join to correlated subquery where tables are related by overlapping ranges
  • How to set 'start with' of sequence to select query result in SQL server?
  • Entity Framework - convert LINQ method chain with SelectMany to query syntax
  • How to migrate a Visual Studio 2012 ASP.Net MVC 4 project to use an SQL Server instance instead of a data file?
  • Removing Non-Numeric Characters from String Fail in a Senario + MS SQL Server
  • SQL - Best practise for a Friendship table
  • Combo box joining two tables from SQL Server database
  • 2 Solutions collect form web for “Compress SQL Server 2005 query results?”

    No. SQL workload is rarely driven by result size. Unless is an ETL job or data shipping, there is never a reason to return a large result to start with. For those particular scenarios that need large amounts of data shipped to the client, there are better solutions than T-SQL queries (log shipping, service broker, replication).

    It is possible to reduce workload dramatically though by improving data model, schema design and the access queries.

    TDS (Tabular Data Stream) compression is something that people have asked Microsoft to implement..but they have not done so yet.

    You have a couple options that I am aware of:

    1. Use a third party tool like SQLNitro.
    2. Move to Windows Server 2008 and SQL Server 2008 where they have made various TCP stack improvements, as outlined here: Appendix A: A Closer Look – Examining the Enhancements in Windows Server 2008 and SQL Server 2008 That Enable Faster Performance
    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.