A friend of my mother's has to twin sons who married two women who had not only the same first name but also worked at the same company. Both ladies took their husbands' names, so they both had the same names. I imagine it must have been both funny and confusing.
When I last worked as a sysadmin, our ERP software used the name as a primary key for employees, so the idea of having two employees with the same name drives me a little bit crazy. (Even worse, though, it did not use FOREIGN KEY constraints but TRIGGERs. I am not sure about performance implications, but from an aesthetical perspective, this is just wrong.)