Kevin Hill disambiguates product offerings:
Let’s break down the main SQL Server editions: Express, Web, Standard, and Enterprise as well as what makes each one different. Not just in features, but in what they let you do… or stop you from doing.
Click through to learn more about each edition, what it offers, and what official limitations exist.
“128GB for the SQL Engine” is just wrong though. I’m not sure why people continue to say this. It’s just the limit for the buffer pool. It’s even documented. Seems willfully ignorant at this point.