In SQL database tables, wny is redundant data generally a bad thing?

And when is it necessary?

(for redundant data I mean same data in multiple tables)