Yes still hangs on Query num 9. Query is bascially fired from our reporting server using Cognos applications. Yes alternative solutions are to spilt the queries but it works fine...

Changed Degree of parallelism to 1 from 4 but same result.

I have somewhat similar issue and hence querying in this thread.

To improve performance plus our Db svr was coming to the end of its warranty we decided to go...