I usually struggle w/ improving queries involving parallelism. Some dbas I've worked with recommended MAXDOP hint.

Even with those recommendations, I notice my queries some time don't use all available CPUs. I'd see it did the work with 8 CPU out of 24+ available to it. Is that necessarily a good thing? Sorry I hope I haven't deviated too much from your topic.