Is there native support for executing queries in parallel from a stored procedure in SQL Server 2008 R2? Take this pseudo code for example
create proc dbo.MySproc
as
delete from SomeTable where Predicate = true [as parallel]
delete from AnotherTable where Predicate = false [as parallel]
[wait for queries]
select * from SomeTable join AnotherTable on Predicate = true
I've seen examples of doing this but they require installing non native CLR procedures which is what I want to avoid.
NOTE: I'm not talking about execution plans, I mean running two non related queries at the same time async, not one after the other.