I have a simple query:
SomethingSlowFunction is a bunch of trigonometric function calls on many columns of the table, all pure T-SQL, no CLR involved.
The query is CPU limited (100% on one of the 8 CPUs).
If I change the query a little bit (i.e. add a SORT BY) that will cause parallel execution but the sort will take a lot of resources (tempdb munching).
View Complete Post