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.