Why is SQL Server's internal database version important?

In this tip, I talk about the compatibility between major versions and SQL Server's internal database version.