Function Differences Among Standard, Web, and Enterprise Editions

Table 1 lists the major differences among the official Microsoft SQL Server editions.

**Table 1** Differences among Microsoft SQL Server editions
Function Item	Web Edition	Standard Edition	Enterprise Edition
High availability	Not supported	Mirror HA	Microsoft SQL Server 2012 (Mirror) Microsoft SQL Server 2014 (Mirror) Microsoft SQL Server 2016 (Mirror) Microsoft SQL Server 2017 (Always On)
Data compression	Supported	Supported	Supported
SQL Profiler	Supported	Supported	Supported
Column index	Not supported	Supported	Supported
Table/index partitioning	Supported	Supported	Supported
Change Data Capture (CDC)	Not supported	Supported	Supported
Parallel searches	Not supported	Not supported	Supported
Adjustment of partitioned table parallelism	Supported	Supported	Supported
Transparent Data Encryption (TDE)	Not supported	Not supported	Supported
Advanced R integration	Not supported	Not supported	Supported