http://www.dfarber.comumbracoenhttp://www.dfarber.com/computer-consulting-blog/2011/7/26/data-compression-in-large-tables-in-ms-sql-server.aspx#comment-16Fri, 09 Sep 2011 18:34:20 GMThttp://www.dfarber.com/computer-consulting-blog/2011/7/26/data-compression-in-large-tables-in-ms-sql-server.aspx#comment-16http://www.dfarber.com/computer-consulting-blog/2011/7/26/data-compression-in-large-tables-in-ms-sql-server.aspx#comment-15Wed, 17 Aug 2011 13:41:46 GMThttp://www.dfarber.com/computer-consulting-blog/2011/7/26/data-compression-in-large-tables-in-ms-sql-server.aspx#comment-15 http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/compressing-data-with-uniqueidentifier-columns

http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/MSSQLServerAdmin/do-you-get-a-benefit-from-compressing-ba
]]>http://www.dfarber.com/computer-consulting-blog/2011/5/16/secure-ms-sql-server-when-running-web-application.aspx#comment-14Thu, 11 Aug 2011 08:37:15 GMThttp://www.dfarber.com/computer-consulting-blog/2011/5/16/secure-ms-sql-server-when-running-web-application.aspx#comment-14http://www.dfarber.com/computer-consulting-blog/2011/3/28/string-manipulation-on-large-data-using-like-operator-or-patindex.aspx#comment-12Fri, 27 May 2011 01:33:08 GMThttp://www.dfarber.com/computer-consulting-blog/2011/3/28/string-manipulation-on-large-data-using-like-operator-or-patindex.aspx#comment-12http://www.dfarber.com/computer-consulting-blog/2011/1/14/processing-hundreds-of-millions-records-got-much-easier.aspx#comment-31Mon, 02 Apr 2012 23:19:09 GMThttp://www.dfarber.com/computer-consulting-blog/2011/1/14/processing-hundreds-of-millions-records-got-much-easier.aspx#comment-31
That problem occurs when the query retrieves large amount of rows. See this article written by Uri Dimant about this problem and how it was resolved at: http://dimantdatabasesolutions.blogspot.com/2009/04/how-to-eat-asyncnetworkio.html

Regards,

Doron
http://www.dfarber.com/microsoft-solutions/mssql-server.aspx


]]>http://www.dfarber.com/computer-consulting-blog/2011/12/26/remove-duplicate-records-in-sql.aspx#comment-30Thu, 29 Mar 2012 06:36:37 GMThttp://www.dfarber.com/computer-consulting-blog/2011/12/26/remove-duplicate-records-in-sql.aspx#comment-30http://www.dfarber.com/computer-consulting-blog/2011/3/28/reasons-for-hiring-an-seo-company-in-usa.aspx#comment-9Tue, 29 Mar 2011 20:50:29 GMThttp://www.dfarber.com/computer-consulting-blog/2011/3/28/reasons-for-hiring-an-seo-company-in-usa.aspx#comment-9http://www.dfarber.com/computer-consulting-blog/2011/1/14/processing-hundreds-of-millions-records-got-much-easier.aspx#comment-5Mon, 28 Mar 2011 00:53:39 GMThttp://www.dfarber.com/computer-consulting-blog/2011/1/14/processing-hundreds-of-millions-records-got-much-easier.aspx#comment-5http://www.dfarber.com/computer-consulting-blog/2011/1/14/processing-hundreds-of-millions-records-got-much-easier.aspx#comment-29Mon, 26 Mar 2012 10:18:17 GMThttp://www.dfarber.com/computer-consulting-blog/2011/1/14/processing-hundreds-of-millions-records-got-much-easier.aspx#comment-29http://www.dfarber.com/computer-consulting-blog/2011/7/20/benefits-of-erp-software-for-small-or-medium-size-businesses.aspx#comment-28Wed, 21 Mar 2012 21:13:05 GMThttp://www.dfarber.com/computer-consulting-blog/2011/7/20/benefits-of-erp-software-for-small-or-medium-size-businesses.aspx#comment-28