且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

压缩SQL Server 2005的查询结果?

更新时间:2023-02-02 22:59:07

没有。 SQL工作量很少结果的大小驱动。除非是一个ETL作业或数据送货,从未有一个理由退换货大结果开始。对于需要大量运到客户端的数据这些特定的情况下,有比T-SQL查询(日志传送,服务代理,复制)更好的解决方案。

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.