Designing Query Strategies Using Multiple Active Result Sets in Microsoft® SQL Server„¢ 2005(4353)



In this 1-hour premium course, you will learn about how to design queries for SQL Server 2005 that take advantage of Multiple Active Result Sets (MARS). Topics include types of queries support by MARS, as well as Concurrency considerations.

Having this experience will enable you to design database applications that efficiently use database server resources.

This course will also prepare you for exam 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft® SQL Server™ 2005.



  • Describe MARS
    • Describe how ADO simulates MARS
    • Describe how MARS Works
    • Use client libraries
    • Use row versioning
    • Describe Snapshot Isolation Level
  • Query Strategies for Multiple Reads per connection
    • Use MARS
    • Identify Alternatives to MARS for Implementing Multiple Active Reads
  • Implement Query Strategies for Mixing Reads and Writes per connection
    • Identify Valid Combinations of Operations
  • Take Concurrency Considerations When Using MARS
    • Identify Locking Behavior
    • Monitor Locks and Blocked Connections
    • Maximize Concurrency When Using MARS


User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-DQS-MA205
  • Duration: 1 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend