Skip to content

Commit 6a01e11

Browse files
committed
Updating features.
1 parent a18f391 commit 6a01e11

1 file changed

Lines changed: 13 additions & 1 deletion

File tree

docs/sql-server/editions-and-components-of-sql-server-2017.md

Lines changed: 13 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -153,13 +153,16 @@ The Developer edition continues to support only 1 client for [SQL Server Distrib
153153
|Basic availability groups <sup>2</sup>|No|Yes<br /><br /> Support for 2 nodes|No|No|No|
154154
|Online page and file restore|Yes|No|No|No|No|
155155
|Online indexing|Yes|No|No|No|No|
156+
|Resumable online index rebuilds|Yes|No|No|No|No|
156157
|Online schema change|Yes|No|No|No|No|
157158
|Fast recovery|Yes|No|No|No|No|
158159
|Mirrored backups|Yes|No|No|No|No|
159160
|Hot add memory and CPU|Yes|No|No|No|No|
160161
|Database recovery advisor|Yes|Yes|Yes|Yes|Yes|
161162
|Encrypted backup|Yes|Yes|No|No|No|
162-
|Hybrid backup to Windows Azure (backup to URL)|Yes|Yes|No|No|No|
163+
|Hybrid backup to Windows Azure (backup to URL)|Yes|Yes|No|No|No|
164+
|Clusterless availability group|Yes|Yes|Yes|No|No|No|
165+
|Minimum replica commit availability group|Yes|Yes|Yes|No|No|No|
163166

164167
<sup>1</sup> For more information on installing SQL Server on Server Core, see [Install SQL Server on Server Core](../database-engine/install-windows/install-sql-server-on-server-core.md).
165168

@@ -170,6 +173,8 @@ The Developer edition continues to support only 1 client for [SQL Server Distrib
170173
|Feature|Enterprise|Standard|Web|Express with Advanced Services|Express|
171174
|-------------|----------------|--------------|---------|------------------------------------|------------------------|
172175
|Columnstore <sup>1</sup>|Yes|Yes|Yes|Yes|Yes|
176+
|Large object binaries in clustered columnstore indexes|Yes|Yes|Yes|Yes|Yes|
177+
|Online non-clustered columnstore index rebuild|Yes|No|No|No|No|
173178
|In-Memory OLTP <sup>1</sup>|Yes|Yes|Yes|Yes, <sup>2</sup>|Yes|
174179
|Stretch Database|Yes|Yes|Yes|Yes|Yes|
175180
|Persistent Main Memory|Yes|Yes|Yes|Yes|Yes|
@@ -183,6 +188,11 @@ The Developer edition continues to support only 1 client for [SQL Server Distrib
183188
|Buffer Pool Extension|Yes|Yes|No|No|No|
184189
|IO Resource Governance|Yes|No|No|No|No|
185190
|Delayed Durability|Yes|Yes|Yes|Yes|Yes|
191+
|Automatic Tuning|Yes|No|No|No|No|
192+
|Batch Mode Adaptive Joins|Yes|No|No|No|No|
193+
|Batch Memory Grant Feedback|Yes|No|No|No|No|
194+
|Bulk insert improvements|Yes|Yes|Yes|Yes|Yes|
195+
186196

187197
<sup>1</sup> In-Memory OLTP data size and Columnstore segment cache are limited to the amount of memory specified by edition in the Scale Limits section. The max degrees of parallelism is limited. The degrees of process parallelism (DOP) for an index build is limited to 2 DOP for the Standard Edition and 1 DOP for the Web and Express Editions. This refers to columnstore indexes created over disk-based tables and memory-optimized tables.
188198

@@ -297,6 +307,8 @@ The Developer edition continues to support only 1 client for [SQL Server Distrib
297307
|Specification of language in query|Yes|Yes|Yes|Yes|No|
298308
|Service Broker (messaging)|Yes|Yes|No (Client only)|No (Client only)|No (Client only)|
299309
|Transact-SQL endpoints|Yes|Yes|Yes|No|No|
310+
|Graph|Yes|Yes|Yes|Yes|Yes|
311+
300312

301313
<sup>1</sup> Scale out with multiple compute nodes requires a head node.
302314

0 commit comments

Comments
 (0)