This article discusses some common ADO properties (cursor location, cursor type and lock type) and their effect on performance. It’s mainly concerned with eliminating server-side cursors. These are identified in Profiler traces by sp_cursorfetch statements.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help