SQL Server Web edition is a low total-cost-of-ownership option for Web hosters and Web VAPs to provide scalability, affordability, and manageability capabilities for small to large scale Web properties. SQL Server Standard edition delivers basic data management and business intelligence database for departments and small organizations to run their applications and supports common development tools for on-premise and cloud - enabling effective database management with minimal IT resources. The premium offering, SQL Server Enterprise edition delivers comprehensive high-end datacenter capabilities with blazing-fast performance, unlimited virtualization, and end-to-end business intelligence - enabling high service levels for mission-critical workloads and end user access to data insights. There are some differences around mirroring (Web can only serve as a witness), publishing (Web can only subscribe), and performance (Web does not come with SQL Profiler). The primary difference is the licensing model, which limits how SQL Server may be used on the server it is installed on. A majority of SQL Server features are available in both SQL Server Web and Standard editions.

SQL Server 2016 includes more features than ever before, but it can be difficult to find the differences between versions of SQL Server.

Sql server enterprise edition