Reply to Re: Size of data-set passed back by a select

Your name:

Reply:


Posted by Mike Epprecht \(SQL MVP\) on 12/20/05 16:51

Hi

How a query is executed depends on the database, hardware, indexes and
statistics. If one of them change, the query may be executed differently.
There is no setting for what you asked.

Have a look at http://www.sql-server-performance.com/blocking.asp

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Mike Collier" <mcollier@btinternet.com> wrote in message
news:1135088905.827499.219210@g44g2000cwa.googlegroups.com...
> When a SQL statement is executed against a SQL Server database is there
> a server-side setting which dictates the size of the fetch buffer? We
> are having some blocking issues on a new server install which do not
> occur on the old server until a much larger volume of data is selected.
> Any help appreciated.
>

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация