Differences between SQL Server editions

Sometimes, developers ask me the difference between the different editions of Microsoft SQL Server like Standard, Workgroup, Enterprise, and so on.

Basically, the differences are in the advanced features (though most small to medium companies are most probably in very good hands with the Standard edition), memory, user and database size limits, licensing, price, and the number of physical processors supported.

However, although such differences can be key sometimes, it must be said that finding information about the differences is indeed somewhat difficult. The information is on MSDN under SQL Server's Books Online, and the main purposes of this blog post is especially this: to share the direct link to the page detailing the differences.

Good luck!