I have a single SELECT statement that returns a large result set (half
a million rows or so). The Client installation is MS SQL Server 2000
and the Server is MS SQL Server 7.0. The OS is Win2K.
On machine number 1, I run the query in Query Analyzer. It sits there
for about half an hour and then displays all the rows in Query
Analyzer. During the half hour, Windows virtual memory usage stays
On machine number 2, I run the query in Query Analyzer. It starts
returning rows to Query Analyzer quickly. As time goes on Windows
virtual memory steadily increases until it maxes out and the process
bombs. (Same server.)
Looks like the two machines are handling cursors in different ways.
My problem is that I don't know how or why the machines are different,
nor how to change it.