Always worth your time, Brent Ozar’s most recent Office Hours covers a couple of scenarios concerning my favorite sacred cow – database normalization.
Does normalization have a big performance impact?
Do foreign keys help with performance?
Normalize until it hurts, de-normalize until it works!