Home Forums Programming CLR Integration and Programming. Custom Aggregate Causing Issues Sometimes RE: Custom Aggregate Causing Issues Sometimes
svenhansen
Grasshopper
Points: 23
More actions
March 3, 2014 at 2:59 pm
#1693708
Long time ago.... but what the hec,
Had same problem on one our 2008 R2 Servers
Setting Max Degree of Parallelism to 1 resolved it.
I am assuming it has something to do with the way the optimizer works with parallel queries (such as a union)