Sibling rivalry is normal — but is it helpful or harmful?

Sibling rivalry is a remarkably normal feature of family life, but too much squabbling and competition can be hurtful, and can have lasting effects on children. What can parents do to manage this when it happens in their family?