Skip to content

Commit ecdd941

Browse files
PRMerger12PRMerger12
authored
Merge pull request #12879 from CarlRabeler/resumable
2019 preview updates
2 parents afdbb79 + 521b1c5 commit ecdd941

3 files changed

Lines changed: 10 additions & 10 deletions

File tree

‎docs/relational-databases/indexes/guidelines-for-online-index-operations.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
---
22
title: Guidelines for Online Index Operations | Microsoft Docs
33
ms.custom: ""
4-
ms.date: 01/14/2019
4+
ms.date: 11/12/2019
55
ms.prod: sql
66
ms.reviewer: ""
77
ms.technology: table-view-index
@@ -87,7 +87,7 @@ Large-scale index operations, performed offline or online, can generate large da
8787
## Resumable index considerations
8888

8989
> [!NOTE]
90-
> The resumable index option applies to SQL Server (Starting with SQL Server 2017) (index rebuild only) and SQL Database (create index and index rebuild). See [Create Index](../../t-sql/statements/create-index-transact-sql.md) (currently in public preview for [!INCLUDE[ssNoVersion](../../includes/sssqlv15-md.md)]) and [Alter Index](../../t-sql/statements/alter-index-transact-sql.md).
90+
> The resumable index option for create index and index rebuild applies to SQL Server (index rebuild starting with SQL Server 2017, with create index also supported in SQL Server 2019) and SQL Database. See [Create Index](../../t-sql/statements/create-index-transact-sql.md) and [Alter Index](../../t-sql/statements/alter-index-transact-sql.md).
9191
9292
When you perform resumable online index create or rebuild, the following guidelines apply:
9393

‎docs/relational-databases/system-catalog-views/sys-index-resumable-operations.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
---
22
title: "sys.index_resumable_operations (Transact-SQL) | Microsoft Docs"
33
ms.custom: ""
4-
ms.date: "01/14/2019"
4+
ms.date: "11/12/2019"
55
ms.prod: sql
66
ms.prod_service: "database-engine, sql-database"
77
ms.reviewer: ""
@@ -25,7 +25,7 @@ monikerRange: "=azuresqldb-current||>=sql-server-2017||=sqlallproducts-allversio
2525

2626
[!INCLUDE[tsql-appliesto-ss2017-asdb-xxxx-xxx-md](../../includes/tsql-appliesto-ss2017-asdb-xxxx-xxx-md.md)]
2727
**sys.index_resumable_operations** is a system view that monitors and checks the current execution status for resumable Index rebuild.
28-
**Applies to**: SQL Server 2017 and Azure SQL Database
28+
**Applies to**: SQL Server (2017 and newer) and Azure SQL Database
2929

3030
|Column name|Data type|Description|
3131
|-----------------|---------------|-----------------|

‎docs/t-sql/statements/create-index-transact-sql.md‎

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
---
22
title: "CREATE INDEX (Transact-SQL) | Microsoft Docs"
33
ms.custom: ""
4-
ms.date: 08/21/2019
4+
ms.date: 11/12/2019
55
ms.prod: sql
66
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
77
ms.reviewer: ""
@@ -489,7 +489,7 @@ For more information, see [How Online Index Operations Work](../../relational-da
489489

490490
RESUMABLE **=** { ON | **OFF**}
491491

492-
**Applies to**: [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] (Starting with [!INCLUDE[sql-server-2019](../../includes/sssqlv15-md.md)]) and [!INCLUDE[ssSDSfull](../../includes/sssdsfull-md.md)] (public preview)
492+
**Applies to**: [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] (Starting with [!INCLUDE[sql-server-2019](../../includes/sssqlv15-md.md)]) and [!INCLUDE[ssSDSfull](../../includes/sssdsfull-md.md)]
493493

494494
Specifies whether an online index operation is resumable.
495495

@@ -501,7 +501,7 @@ Index operation is not resumable.
501501

502502
MAX_DURATION **=** *time* [**MINUTES**] used with **RESUMABLE = ON** (requires **ONLINE = ON**)
503503

504-
**Applies to**: [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] (Starting with [!INCLUDE[sql-server-2019](../../includes/sssqlv15-md.md)]) and [!INCLUDE[ssSDSfull](../../includes/sssdsfull-md.md)] (public preview)
504+
**Applies to**: [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] (Starting with [!INCLUDE[sql-server-2019](../../includes/sssqlv15-md.md)]) and [!INCLUDE[ssSDSfull](../../includes/sssdsfull-md.md)]
505505

506506
Indicates time (an integer value specified in minutes) that a resumable online index operation is executed before being paused.
507507

@@ -745,7 +745,7 @@ The following guidelines apply for performing index operations online:
745745
For more information, see [Perform Index Operations Online](../../relational-databases/indexes/perform-index-operations-online.md).
746746

747747
### <a name="resumable-indexes"></a>Resumable index operations
748-
**Applies to**: [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] (Starting with [!INCLUDE[sql-server-2019](../../includes/sssqlv15-md.md)]) and [!INCLUDE[ssSDSfull](../../includes/sssdsfull-md.md)] (public preview)
748+
**Applies to**: [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] (Starting with [!INCLUDE[sql-server-2019](../../includes/sssqlv15-md.md)]) and [!INCLUDE[ssSDSfull](../../includes/sssdsfull-md.md)]
749749

750750
The following guidelines apply for resumable index operations:
751751

@@ -1095,7 +1095,7 @@ GO
10951095
```
10961096

10971097
### M. Create, resume, pause, and abort resumable index operations
1098-
**Applies to**: [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] (Starting with [!INCLUDE[sql-server-2019](../../includes/sssqlv15-md.md)]) and [!INCLUDE[ssSDSfull](../../includes/sssdsfull-md.md)] (public preview)
1098+
**Applies to**: [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] (Starting with [!INCLUDE[sql-server-2019](../../includes/sssqlv15-md.md)]) and [!INCLUDE[ssSDSfull](../../includes/sssdsfull-md.md)]
10991099

11001100
```sql
11011101
-- Execute a resumable online index create statement with MAXDOP=1
@@ -1124,7 +1124,7 @@ ALTER INDEX test_idx2 ON test_table ABORT;
11241124
### N. Basic syntax
11251125
Create, resume, pause, and abort resumable index operations
11261126

1127-
**Applies to**: [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] (Starting with [!INCLUDE[sql-server-2019](../../includes/sssqlv15-md.md)]) and [!INCLUDE[ssSDSfull](../../includes/sssdsfull-md.md)] (public preview)
1127+
**Applies to**: [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] (Starting with [!INCLUDE[sql-server-2019](../../includes/sssqlv15-md.md)]) and [!INCLUDE[ssSDSfull](../../includes/sssdsfull-md.md)]
11281128

11291129
```sql
11301130
-- Execute a resumable online index create statement with MAXDOP=1

0 commit comments

Comments
 (0)