Also force maxdop to 0 if your server isn't already set to it....a horrible, awful query like that should eat up every available core.