Obsessive Personalities with Robert Shaw

Obsessive personalities are those people who pursue excellence at all costs; sometimes to the detriment of relationships on the team and in the organization. When is this obesssiveness helpful and when is harmful? If you are working with or leading such a personality, how do you get the best of that person and avoid the worst?