MSDN Webcast: Improving Smart Client Performance Using MARS (Multiple Active Result Sets) in SQL Server 2005 (Level 300) 
Event ID: 1032271743
|
|
|
|
|
Language(s):
|
English.
|
|
Product(s):
|
Microsoft SQL Server.
|
|
Audience(s):
|
Pro Dev/Programmer.
|
|
|
|
|
|
|
|
Duration:
|
60 Minutes
|
|
Start Date:
|
Friday, April 08, 2005 12:00 AM
|
|
|
|
|
Event Overview
|
All Microsoft SQL Server data access 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. Several alternatives have been implemented to work around this limitation, of which server-side cursors is probably the most common. SQL Server 2005 introduces Multiple Active Result Sets (MARS), which removes
this constraint. This session explores the design, architecture, and semantic changes in MARS and what considerations you should take into account to get maximum benefit out of these improvements.
Presenter: Christian Kleinerman, Program Manager, Microsoft Corporation
Register to view this on-demand webcast and download a .wmv of the webcast now. By registering, you will also receive a confirmation email the following
day with a link to the PPT download.
To avoid possible problems, we suggest you temporarily disable pop-up blocker software before viewing the webcast.
View other sessions from
SQL Server 2005: Discover the Next Paradigm for Database Development.
Questions? Feedback? Use
Webcast Contact Us
|
|
|
|
| Registration Options |
|
Event ID:
1032271743
|
|
|
|
|
|
|
|
|
