Dana - how could I resist this one...:)?
Sorry if some of these have been mentioned before and also some different songs for the same names.

My favorite names on the list are probably Alice, Samantha and Livia...

Alice – Tom Waits
Amber Waves – Tori Amos
Ana – Pixies
Annie – Elastica
Ava Adore – Smashing Pumpkins
Clair – My Bloody Valentine
Condoleeza, Check My Posse – The Majestic Twelve
Éireann – Afro Celt Sound System
Goodnight Irene – Pere Ubu
Jacqueline – Franz Ferdinand
Jennifer’s Veil – The Birthday Party
Jolene – Ray Lamontagne
Judith – A Perfect Circle
Katie Stood On The Benches – Goya Dress
Kelly’s heroes – Black Grape
Livia – Drugstore
Lola – The Kinks
It’s Lulu – The Boo Radleys
Mona Lisas and Mad Hatters – Elton John
Pauline – Eleni Mandell
I Heard Ramona Sing – Frank Black
Whole Lotta Rosie – AC/DC
Ruby’s Arms – Tom Waits
Sally MacLennane – The Pogues
Lady Samantha – Elton John
To Sheila – Smashing Pumpkins
Susan’s house – Eels
Suzanne – Leonard Cohen
Nicotina – Big Sugar
Valerie – The Zutons
Violet – Hole
Willow – Joan Armatrading