(To view a larger image with more detailed description tap or click its thumbnail.)
Have you ever been driven mad by your iPhone reminding you that you received a text message multiple times?
To stop this annoyance, open Settings, then select Messages, and finally slide the Repeat Alert to the Off position.
UPDATE (04/15/2011): On iOS 4.3, this has changed slightly. Continue on to Messages, but instead of selecting Repeat Alert, tap Play Alert Tone followed by the Once option.