concept person in category sql

This is an excerpt from Manning's book SQL Server MVP Deep Dives.
For OLTP or operational databases (not reporting databases or BI) a correctly indexed normalized schema will nearly always perform better than a denormalized one. The extra work required to double insert, double update, or pivot denormalized data when reading will almost always cost more than the perceived benefit of reading from a single denormalized location. Unless you do performance testing and know your application’s profile, it is likely that when you denormalize, you’re introducing performance problems that would have been easy to avoid by learning better SQL practices. But the root cause of most less-than-normalized databases isn’t an effort to improve performance; it’s the incompetence of the person designing the database and the programmers writing the queries.
SELECT person_id, first_name, last_name, birth_date, email
FROM persons WHERE email LIKE '%' + @word + '%'