Multiple Active Result Sets (MARS)
E277028
Multiple Active Result Sets (MARS) is a SQL Server feature that allows a single database connection to execute and process multiple batches or result sets concurrently.
All labels observed (2)
| Label | Occurrences |
|---|---|
| Multiple Active Result Sets | 1 |
| Multiple Active Result Sets (MARS) canonical | 1 |
How this entity was disambiguated
This entity first appeared as the object of triple T2556583 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.
NED1
Entity disambiguation (via context triple)
gpt-5-mini-2025-08-07
Target entity: Multiple Active Result Sets (MARS) Context triple: [.NET Data Provider for SQL Server, supportsFeature, Multiple Active Result Sets (MARS)]
-
A.
Jakarta Transactions
Jakarta Transactions is the Jakarta EE specification that defines a standard API and infrastructure for managing distributed transactions in Java enterprise applications.
-
B.
JDBC
JDBC (Java Database Connectivity) is a Java-based API that enables applications to connect to and interact with relational databases in a standardized way.
-
C.
maîtres des requêtes
Maîtres des requêtes are mid- to high-ranking members of the French Council of State who assist in legal analysis, case instruction, and advisory work for the government.
-
D.
RDS
RDS is a Canadian French-language sports television network that broadcasts a wide range of professional and amateur sporting events.
-
E.
ODBC
ODBC (Open Database Connectivity) is a standard API that enables applications to access and query data from a wide variety of relational and non-relational database management systems using a common interface.
- F. None of above. chosen
- G. Unsure - the case is ambiguous/there is not enough information to decide.
NED2
Entity disambiguation (via description)
gpt-5-mini-2025-08-07
Target entity: Multiple Active Result Sets (MARS) Target entity description: Multiple Active Result Sets (MARS) is a SQL Server feature that allows a single database connection to execute and process multiple batches or result sets concurrently.
-
A.
Jakarta Transactions
Jakarta Transactions is the Jakarta EE specification that defines a standard API and infrastructure for managing distributed transactions in Java enterprise applications.
-
B.
JDBC
JDBC (Java Database Connectivity) is a Java-based API that enables applications to connect to and interact with relational databases in a standardized way.
-
C.
maîtres des requêtes
Maîtres des requêtes are mid- to high-ranking members of the French Council of State who assist in legal analysis, case instruction, and advisory work for the government.
-
D.
RDS
RDS is a Canadian French-language sports television network that broadcasts a wide range of professional and amateur sporting events.
-
E.
ODBC
ODBC (Open Database Connectivity) is a standard API that enables applications to access and query data from a wide variety of relational and non-relational database management systems using a common interface.
- F. None of above. chosen
Statements (47)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server feature
ⓘ
database connection feature ⓘ |
| abbreviation | MARS ⓘ |
| affects | transaction semantics on a single connection ⓘ |
| alsoKnownAs | MARS feature ⓘ |
| appliesToProduct |
SQL Server
ⓘ
surface form:
Microsoft SQL Server
SQL Server Native Client ⓘ |
| behavior |
allows multiple pending requests on a single connection
ⓘ
allows partial consumption of one result set before switching to another ⓘ |
| benefit |
enables more responsive applications with interleaved queries
ⓘ
reduces need for multiple connections per session ⓘ simplifies certain application data access patterns ⓘ |
| category |
SQL Server connectivity
ⓘ
database concurrency feature ⓘ |
| configuredBy | connection string parameter MultipleActiveResultSets ⓘ |
| connectionStringKeyword | MultipleActiveResultSets ⓘ |
| connectionStringValueExample | MultipleActiveResultSets=True ⓘ |
| defaultState | disabled ⓘ |
| developedBy | Microsoft ⓘ |
| documentationSection | SQL Server Books Online ⓘ |
| enables |
execution of multiple batches on a single connection
ⓘ
interleaved processing of multiple result sets ⓘ multiple active result sets on a single database connection ⓘ reusing a single connection for concurrent queries ⓘ |
| introducedIn |
SQL Server
ⓘ
surface form:
Microsoft SQL Server 2005
|
| limitation |
commands share the same underlying connection resources
ⓘ
does not provide true parallel execution on a single connection ⓘ may increase server resource usage ⓘ not supported in all SQL Server client providers ⓘ |
| relatedConcept |
TDS protocol
ⓘ
database connection pooling ⓘ server-side cursors ⓘ |
| requires |
SQL Server Native Client
ⓘ
surface form:
SQL Server Native Client provider
special handling of transactions across multiple active commands ⓘ |
| requiresClientVersionAtLeast |
SQL Server Native Client
ⓘ
surface form:
SQL Server Native Client 2005
|
| requiresServerVersionAtLeast |
SQL Server
ⓘ
surface form:
SQL Server 2005
|
| scope | per-connection setting ⓘ |
| standsFor |
Multiple Active Result Sets (MARS)
self-linksurface differs
ⓘ
surface form:
Multiple Active Result Sets
|
| supportsLanguage | T-SQL ⓘ |
| supportsScenario |
MARS-enabled ADO.NET SqlClient operations
ⓘ
nested data access operations on a single connection ⓘ reading from one result set while executing another command ⓘ server-side cursors with overlapping commands ⓘ |
| usedWith |
.NET Data Provider for SQL Server
ⓘ
surface form:
ADO.NET SqlClient
ODBC ⓘ OLE DB ⓘ |
| warning | improper use can lead to complex debugging and resource contention ⓘ |
How these facts were elicited
The pipeline generated the facts above by prompting gpt-5.1 with this entity's name + description and the instruction below.
Instruction
You are a knowledge base construction expert. Given a subject entity and a description of it, return factual statements that you know for the subject as a JSON list of dictionaries(triples), where keys must be "subject", "predicate" and "object". The number of facts may be very high, between 25 to 50 or more, for very popular subjects. For less popular subjects, the number of facts can be very low, like 5 or 10. # Requirements - If you don't know the subject at all, return an empty list. - If the subject is not a named entity, return an empty list. - Include at least one triple where predicate is "instanceOf". - Do not get too wordy. - Separate several objects into multiple triples with one object.
Input
Subject: Multiple Active Result Sets (MARS) Description of subject: Multiple Active Result Sets (MARS) is a SQL Server feature that allows a single database connection to execute and process multiple batches or result sets concurrently.
Referenced by (2)
Full triples — surface form annotated when it differs from this entity's canonical label.
Multiple Active Result Sets (MARS)
→
standsFor
→
Multiple Active Result Sets (MARS)
self-linksurface differs
ⓘ
subject surface form:
MARS
this entity surface form:
Multiple Active Result Sets