Skip to content

Commit f9dbc18

Browse files
MikeRayMSFTMikeRayMSFT
committed
Remove incorrect hypehnation
1 parent 43db82f commit f9dbc18

8 files changed

Lines changed: 13 additions & 13 deletions

‎docs/2014/relational-databases/data-tier-applications/dac-support-for-sql-server-objects-and-versions.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -34,7 +34,7 @@ manager: craigg
3434
|-|-|
3535
|DATABASE ROLE|FUNCTION: Inline Table-valued|
3636
|FUNCTION: Multistatement Table-valued|FUNCTION: Scalar|
37-
|INDEX: Clustered|INDEX: Non-clustered|
37+
|INDEX: Clustered|INDEX: Nonclustered|
3838
|INDEX: Spacial|INDEX: Unique|
3939
|LOGIN|Permissions|
4040
|Role Memberships|SCHEMA|

‎docs/2014/relational-databases/in-memory-oltp/estimate-memory-requirements-for-memory-optimized-tables.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -123,7 +123,7 @@ SELECT COUNT(DISTINCT [Col2])
123123

124124
**Memory for non-clustered indexes**
125125

126-
Non-clustered indexes are implemented as BTrees with the inner nodes containing the index value and pointers to subsequent nodes. Leaf nodes contain the index value and a pointer to the table row in memory.
126+
Nonclustered indexes are implemented as BTrees with the inner nodes containing the index value and pointers to subsequent nodes. Leaf nodes contain the index value and a pointer to the table row in memory.
127127

128128
Unlike hash indexes, non-clustered indexes do not have a fixed bucket size. The index grows and shrinks dynamically with the data.
129129

@@ -136,7 +136,7 @@ SELECT COUNT(DISTINCT [Col2])
136136
The leaf nodes have one row for each unique key in the table that points to the data rows with that unique key. If you have multiple rows with the same key (i.e., you have a non-unique non-clustered index), there is only one row in the index leaf node that points to one of the rows with the other rows linked to each other. Thus, the total memory required can be approximated by:
137137
memoryForNonClusteredIndex = (pointerSize + sum(keyColumnDataTypeSizes)) * rowsWithUniqueKeys
138138

139-
Non-clustered indexes are best when used for range lookups, as exemplified by the following query:
139+
Nonclustered indexes are best when used for range lookups, as exemplified by the following query:
140140

141141
```sql
142142

‎docs/2014/ssms/agent/select-an-account-for-the-sql-server-agent-service.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -68,7 +68,7 @@ manager: craigg
6868
## Supported Service Account Types
6969
The following table lists the Windows account types that can be used for the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Agent service.
7070

71-
|Service account type|Non-clustered Server|Clustered server|Domain controller (non-clustered)|
71+
|Service account type|Nonclustered Server|Clustered server|Domain controller (non-clustered)|
7272
|--------------------------|---------------------------|----------------------|------------------------------------------|
7373
|[!INCLUDE[msCoName](../../includes/msconame-md.md)] Windows domain account (member of Windows Administrators group)|Supported|Supported|Supported|
7474
|Windows domain account (non-administrative)|Supported<sup>1</sup>|Supported<sup>1</sup>|Supported<sup>1</sup>|

‎docs/relational-databases/data-tier-applications/dac-support-for-sql-server-objects-and-versions.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -43,7 +43,7 @@ ms.author: "sstein"
4343
|-|-|
4444
|DATABASE ROLE|FUNCTION: Inline Table-valued|
4545
|FUNCTION: Multistatement Table-valued|FUNCTION: Scalar|
46-
|INDEX: Clustered|INDEX: Non-clustered|
46+
|INDEX: Clustered|INDEX: Nonclustered|
4747
|INDEX: Spacial|INDEX: Unique|
4848
|LOGIN|Permissions|
4949
|Role Memberships|SCHEMA|

‎docs/relational-databases/in-memory-oltp/estimate-memory-requirements-for-memory-optimized-tables.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -139,7 +139,7 @@ Since we have three hash indexes, the memory needed for the hash indexes is 3 *
139139

140140
#### Memory for non-clustered indexes
141141

142-
Non-clustered indexes are implemented as BTrees with the inner nodes containing the index value and pointers to subsequent nodes. Leaf nodes contain the index value and a pointer to the table row in memory.
142+
Nonclustered indexes are implemented as BTrees with the inner nodes containing the index value and pointers to subsequent nodes. Leaf nodes contain the index value and a pointer to the table row in memory.
143143

144144
Unlike hash indexes, non-clustered indexes do not have a fixed bucket size. The index grows and shrinks dynamically with the data.
145145

@@ -152,7 +152,7 @@ Memory needed by non-clustered indexes can be computed as follows:
152152
The leaf nodes have one row for each unique key in the table that points to the data rows with that unique key. If you have multiple rows with the same key (i.e., you have a non-unique non-clustered index), there is only one row in the index leaf node that points to one of the rows with the other rows linked to each other. Thus, the total memory required can be approximated by:
153153
- memoryForNonClusteredIndex = (pointerSize + sum(keyColumnDataTypeSizes)) * rowsWithUniqueKeys
154154

155-
Non-clustered indexes are best when used for range lookups, as exemplified by the following query:
155+
Nonclustered indexes are best when used for range lookups, as exemplified by the following query:
156156

157157
```sql
158158
SELECT * FRON t_hk

‎docs/relational-databases/system-catalog-views/sys-pdw-nodes-indexes-transact-sql.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -22,8 +22,8 @@ monikerRange: ">= aps-pdw-2016 || = azure-sqldw-latest || = sqlallproducts-allve
2222
|-----------------|---------------|-----------------|-----------|
2323
|object_id|**int**|id of the object to which this index belongs.||
2424
|name|**sysname**|Name of the index. Name is unique only within the object. NULL = Heap||
25-
|index_id|**int**|id of the index. index_id is unique only within the object.<br /><br /> 0 = Heap<br /><br /> 1 = Clustered index<br /><br /> > 1 = Non-clustered index||
26-
|type|**tinyint**|Type of index:<br /><br /> 0 = Heap<br /><br /> 1 = Clustered<br /><br /> 2 = Non-clustered<br /><br /> 5 = Clustered xVelocity memory optimized columnstore index|
25+
|index_id|**int**|id of the index. index_id is unique only within the object.<br /><br /> 0 = Heap<br /><br /> 1 = Clustered index<br /><br /> > 1 = Nonclustered index||
26+
|type|**tinyint**|Type of index:<br /><br /> 0 = Heap<br /><br /> 1 = Clustered<br /><br /> 2 = Nonclustered<br /><br /> 5 = Clustered xVelocity memory optimized columnstore index|
2727
|type_desc|**nvarchar(60)**|Description of index type:<br /><br /> HEAP<br /><br /> CLUSTERED<br /><br /> NONCLUSTERED<br /><br /> CLUSTERED COLUMNSTORE||
2828
|is_unique|**bit**|0 = Index is not unique.|Always 0.|
2929
|data_space_id|**int**|id of the data space for this index. Data space is either a filegroup or partition scheme.<br /><br /> 0 = object_id is a table-valued function.||

‎docs/relational-databases/system-stored-procedures/sp-estimate-data-compression-savings-transact-sql.md‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -110,8 +110,8 @@ sp_estimate_data_compression_savings
110110
|-----------------|---------------|
111111
|Heap|Clustered columnstore index|
112112
|Clustered index|Clustered columnstore index|
113-
|Non-clustered index|Non-clustered columnstore index (including the key columns and any included columns of the provided non-clustered index, as well as the partition column of the table, if any)|
114-
|Non-clustered columnstore index|Non-clustered columnstore index (including the same columns as the provided non-clustered columnstore index)|
113+
|Nonclustered index|Nonclustered columnstore index (including the key columns and any included columns of the provided non-clustered index, as well as the partition column of the table, if any)|
114+
|Nonclustered columnstore index|Nonclustered columnstore index (including the same columns as the provided non-clustered columnstore index)|
115115
|Clustered columnstore index|Clustered columnstore index|
116116

117117
> [!NOTE]
@@ -122,7 +122,7 @@ sp_estimate_data_compression_savings
122122
|Source Object|Reference Object|
123123
|-----------------|---------------|
124124
|Clustered columnstore index|Heap|
125-
|Non-clustered columnstore index|Non-clustered index (including the columns contained in the non-clustered columnstore index as key columns, and the partition column of the table, if any, as an included column)|
125+
|Nonclustered columnstore index|Nonclustered index (including the columns contained in the non-clustered columnstore index as key columns, and the partition column of the table, if any, as an included column)|
126126

127127
> [!NOTE]
128128
> When estimating rowstore compression (NONE, ROW or PAGE) from a columnstore source object, be sure that the source index does not contain more than 32 columns as this is the limit supported in a rowstore (non-clustered) index.

‎docs/ssms/agent/select-an-account-for-the-sql-server-agent-service.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -74,7 +74,7 @@ The account that the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] A
7474
## Supported Service Account Types
7575
The following table lists the Windows account types that can be used for the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Agent service.
7676

77-
|Service account type|Non-clustered Server|Clustered server|Domain controller (non-clustered)|
77+
|Service account type|Nonclustered Server|Clustered server|Domain controller (non-clustered)|
7878
|------------------------|-------------------------|--------------------|--------------------------------------|
7979
|[!INCLUDE[msCoName](../../includes/msconame_md.md)] Windows domain account (member of Windows Administrators group)|Supported|Supported|Supported|
8080
|Windows domain account (non-administrative)|Supported<br /><br />See Limitation 1 below.|Supported<br /><br />See Limitation 1 below.|Supported<br /><br />See Limitation 1 below.|

0 commit comments

Comments
 (0)