If you want to see how popular your first or last name was in the 1990 Census, there is a free website by the U.S. Census Bureau that does just that. http://www.census.gov/genealogy/names/ will allow you to search your first and last name to find out how popular it ranked in 1990.
For example, Katie ranked 193 in the 1990 Census. It is a fairly common first name. And my maiden name, Lund, ranked 1354 for surnames. My married name wasn't even in the census though. Since my first name is so common, it's kind of fun to have an uncommon last name.