Along the time Microsoft improve performance and add features to the SQL Server Database. The two principals editions are Enterprise and Standard edition (EE and SE) but there are also others versions like the web edition or the free one : the Express Edition.

During the evolution of SQL Server, there was a kind of rupture in the gap between Enterprise Edition and the Standard one. Indeed, the 2016 version marked a shift that saw the Standard edition get closer to the enterprise edition in terms of available features

In the following dashboard, you can see the different features available or not for the Standard Edition and the physical limitations of the SE (CPU/RAM/Size)