So the choice is between "Where is it?" and "Where's it at?", and the latter, a strong anapest, is prettier and trips off the tongue better than "Where is it?", whose meter is either a clunky monosyllabic-foot + trochee or it's nothing at all.
David Foster Wallace
Authority and American Usage