Disadvantages of MARS (Multiple Active Result Sets)?
There are apparently at least two known (potential) drawbacks (from this (1) Team blog): Obviously this can cause potential problems for any legacy systems which weren’t designed to run against a MARS enabled design – “existing code optimized to run in the non-MARS world may show a slight performance dip when run un-modified with MARS” … Read more