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.
>

• Next in forum: Re: Size of data-set passed back by a select
• Prev in forum: Re: Size of data-set passed back by a select
• Thread view: Re: Size of data-set passed back by a select

[Reply to this message]