Skip to content

Commit 3c27502

Browse files
MightyPenMightyPen
authored
Merge branch 'master' into FromPublicRepo
2 parents efc26eb + ecdd941 commit 3c27502

4 files changed

Lines changed: 11 additions & 11 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-database-files-transact-sql.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -30,7 +30,7 @@ monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-s
3030
|-----------------|---------------|-----------------|
3131
|**file_id**|**int**|ID of the file within database.|
3232
|**file_guid**|**uniqueidentifier**|GUID for the file.<br /><br /> NULL = Database was upgraded from an earlier version of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] (Valid for SQL Server 2005 and earlier).|
33-
|**type**|**tinyint**|File type:<br /><br /> 0 = Rows (Includes files of full-text catalogs that are upgraded to or created in [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)].)<br /><br /> 1 = Log<br /><br /> 2 = FILESTREAM<br /><br /> 3 = [!INCLUDE[ssInternalOnly](../../includes/ssinternalonly-md.md)]<br /><br /> 4 = Full-text (Full-text catalogs earlier than [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)]; full-text catalogs that are upgraded to or created in [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)] will report a file type 0.)|
33+
|**type**|**tinyint**|File type:<br/><br /> 0 = Rows<br /><br/> 1 = Log<br/><br /> 2 = FILESTREAM<br /><br /> 3 = [!INCLUDE[ssInternalOnly](../../includes/ssinternalonly-md.md)]<br /><br /> 4 = Full-text|
3434
|**type_desc**|**nvarchar(60)**|Description of the file type:<br /><br /> ROWS (Includes files of full-text catalogs that are upgraded to or created in [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)].)<br /><br /> LOG<br /><br /> FILESTREAM<br /><br /> FULLTEXT (Full-text catalogs earlier than [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)].)|
3535
|**data_space_id**|**int**|Value can be 0 or greater than 0. A value of 0 represents the database log file, and a value greater than 0 represents the ID of the filegroup where this data file is stored.|
3636
|**name**|**sysname**|Logical name of the file in the database.|

‎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 or creation.
28-
**Applies to**: SQL Server 2017, SQL Server 2019, 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)