In general I run a campaign where the magic to bring someone back is available...but expensive or otherwise difficult to get hold of, particularly at low levels.
When the current party was about 5th level they fought a large band of orcs (8, I believe, all standard); the primary fighter managed to get flanked two ways (that is, by four orcs) and went down hard. They didn't have the money or any other resources to get her brought back...off to the outer planes with her, a new character was rolled up.
The same party, the same player (new character) a few levels later: As the primary fighter, again, she steps out to battle with two Yuan-ti Abominations after taking quite a pounding from their guards...she goes down again. This time the party had the treasure (espesially after raiding the Yuan-ti) and was willing to spend it to have a cleric bring her back...something on the order of 20,000gp, if I remember rightly.
Character death is not too common in the games I run, but it does occur...when it does, I want the party to have the option, prohibitive as it may seem, to bring a character back. It is fantasy, after all.