I tested the query with just 15000 records. The performance is not to an acceptable level. Processor stays 100% during the entire duration of the execution of the...
The problem is related to record paging using sqlserver. I am using .NET to access sqlserver. There is no concept of connected recordset with sqlserver in .NET which means no...