We sometimes see this called "predicate pushing". I.e., the option (for the database engine) to push a predicate in the outer query into an inner query. I wouldn't mind an optimizer hint to disable PP, just as you mention. I recommend you report this request at connect.microsoft.com...
The suspensions were gently stirred using a small magnetic bean during the fluorescence measurements. The maximum quantum yield (𝐹𝑣/𝐹𝑚Fv/Fm; the ratio of variable to maximum chlorophyll fluorescence from photosystem II) was measured at time zero (𝑛=6n=6). After dark incubation, a ...
●The modules offer lower Mean Time To Repair (MTTR). One vendor means one support center to decrease troubleshooting time and eliminate finger pointing among vendors. ●Cisco SMARTnet®support covers both integrated services routers and Cisco EtherSwitch devices. ...