You could design a SQL database to be denormalized from the start, but then you are losing many of the advantages of a SQL database.
I never said that schemas aren't necessary, just that using a strict NoSQL database forces you to think about scaling constraints early. This avoids(atleast partially) a schema redesign later.
Ah yes! Optimize early, that's what my teachers always told me to do. /s
Surely this depends on how you set up your SQL database to begin with? I'm not familiar with NoSQL, so can you explain why "schemas" aren't necessary and scaling happens automatically?