Custom Aggregate Causing Issues Sometimes

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  November 9, 2012 at 2:41 pm

  #1557810

  Good to know, you're welcome. Thanks for posting back that you found a path forward!

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• 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)