All Microsoft SQL Server data access application programming interfaces (APIs) provide an abstraction to represent sessions and requests within those sessions. SQL Server 2000 and earlier restricted the programming model such that at any point in time there would be at most one pending request on a given session. SQL Server 2005 implements Multiple Active Result Sets (MARS), which removes this constraint. This paper explains the design, architecture, and semantic changes in MARS and what considerations must be taken into account by applications to get the maximum benefit out of these improvements.
Did you find this white paper useful?
23 out of 50 users found this white paper useful
Related white papers
Oracle 10g R2 RAC Implementation With SLES 10 Linux, IBM BladeCenter and IBM TotalStorage
The purpose of this paper is to assist those who are implementing Oracle Real Application Clusters on SuSE Linux Enterprise Server 10 running on IBM BladeCenter servers and IBM TotalStorage...
Configuration Options for Handling Application Dispatch Timeouts
In the WebSphere environment, the application servers must cope with a variety of work requests. In normal operations, the servers handle the beans, servlets, and other the types of application...
EPL Inc. Builds Software Products Seven Times Faster, Reinvigorates Sales and Marketing, Achieves 793% ROI With Oracle Technology Platform and Collaboration Suite
Since 1977, EPL Inc. has been a top provider of technology to these nonprofit financial institutions, creating software products and services that run the credit union's core business systems, from...
Croatia-Based Oil Firm Enhances Operations, Achieves 100 Per Cent Accurate Retail Data
INA is a leading oil and gas provider in Croatia. Established in 1964, the company employs more than 15,000 people at its regional offices, and gas and retail stores. Until...
Braathens's Implements Integrated CRM System in Only 75 Days
Braathens ASA is an airline company in Norway. Braathens's success as an airline is based on strong marketing - telephone, internet, and direct marketing - to continually grow its customer...
Oracle OLAP Tools Improve Decision Making for Musgrave
Musgrave SuperValu-Centra (MSVC) is Ireland's largest grocery and food distributor. It wanted to integrate business intelligence tools to support decision making, perform multidimensional data analysis and calculation and leverage existing...
Paper Company Maximizes Sales Effectiveness Through Centralized CRM
Catalyst Paper is one of North America's largest manufacturers of mechanical paper, producing more than 2.4 million metric tons of paper products per year. Despite the company's success, salespeople found...
