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.
[…] first major topic was jumped off of a comment from Erik Darling around SQL Server editions. Erik correctly notes that Standard Edition does not mean 128 GB of RAM for the database […]