MARS - Multiple Active Result Sets support in SQL Server 2005 and abov(blog.typps.com)
submitted by
alessandrokicks(195) 1 year, 1 month ago
SQL Server 2005 onwards supports MARS - Multiple Active Result Sets. MARS enables you to reuse an existing connection to perform operations on SQL Server.
This makes MARS a viable alternative to server-side cursors with significant performance boosts. As powerful that may seem it has it's drawbacks so care needs to be taken when using it.
|category: ADO.NET
|Views: 1
tags:
ADO.NET Database another
Everyones tags:
Your Tags: