Does a .NET SqlDataReader object created by Connection.ExecuteReader() use a db Cursor or the whole SELECT's ResultSet is loaded into RAM?
Does a .NET SqlDataReader object use a database cursor, or is the whole result set loaded into RAM?