Linkfix:SQL 2021-09) - 2

v-kents · v-kents · commit 3c6014227161 · 2021-09-07T13:17:09.000-07:00
diff --git a/docs/reporting-services/tools/reporting-services-in-sql-server-data-tools-ssdt.md b/docs/reporting-services/tools/reporting-services-in-sql-server-data-tools-ssdt.md
@@ -311,4 +311,4 @@ ms.author: maggies
 [Report Definition Language](../../reporting-services/reports/report-definition-language-ssrs.md)   
 [Deployment and Version Support in SQL Server Data Tools](../../reporting-services/tools/deployment-and-version-support-in-sql-server-data-tools-ssrs.md)  
 
-More questions? [Try asking the Reporting Services forum](https://go.microsoft.com/fwlink/?LinkId=620231)
+More questions? [Try asking the Reporting Services forum](/answers/search.html?c=&f=&includeChildren=&q=ssrs+OR+reporting+services&redirect=search%2fsearch&sort=relevance&type=question+OR+idea+OR+kbentry+OR+answer+OR+topic+OR+user)
diff --git a/docs/reporting-services/tools/server-properties-advanced-page-reporting-services.md b/docs/reporting-services/tools/server-properties-advanced-page-reporting-services.md
@@ -255,4 +255,4 @@ Indicates whether the report server should use session cookies when communicatin
 [Script Deployment and Administrative Tasks](../../reporting-services/tools/script-deployment-and-administrative-tasks.md)   
 [Enable and Disable My Reports](../../reporting-services/report-server/enable-and-disable-my-reports.md)  
 
-More questions? [Try asking the Reporting Services forum](https://go.microsoft.com/fwlink/?LinkId=620231)
+More questions? [Try asking the Reporting Services forum](/answers/search.html?c=&f=&includeChildren=&q=ssrs+OR+reporting+services&redirect=search%2fsearch&sort=relevance&type=question+OR+idea+OR+kbentry+OR+answer+OR+topic+OR+user)
diff --git a/docs/reporting-services/tools/tutorial-how-to-locate-and-start-reporting-services-tools-ssrs.md b/docs/reporting-services/tools/tutorial-how-to-locate-and-start-reporting-services-tools-ssrs.md
@@ -182,4 +182,4 @@ You can install it from the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md
 [Query Design Tools](../../reporting-services/report-data/query-design-tools-ssrs.md)  
 [Reporting Services Tutorials](../../reporting-services/reporting-services-tutorials-ssrs.md)  
 
-More questions? [Try asking the Reporting Services forum](https://go.microsoft.com/fwlink/?LinkId=620231)
+More questions? [Try asking the Reporting Services forum](/answers/search.html?c=&f=&includeChildren=&q=ssrs+OR+reporting+services&redirect=search%2fsearch&sort=relevance&type=question+OR+idea+OR+kbentry+OR+answer+OR+topic+OR+user)
diff --git a/docs/reporting-services/tutorial-add-a-sparkline-to-your-report-report-builder.md b/docs/reporting-services/tutorial-add-a-sparkline-to-your-report-report-builder.md
@@ -318,4 +318,4 @@ This concludes the tutorial for creating a table report with sparkline charts. F
 [Report Builder Tutorials](../reporting-services/report-builder-tutorials.md) 
 [Report Builder in SQL Server](../reporting-services/report-builder/report-builder-in-sql-server-2016.md)  
 
-More questions? [Try asking the Reporting Services forum](https://go.microsoft.com/fwlink/?LinkId=620231)
+More questions? [Try asking the Reporting Services forum](/answers/search.html?c=&f=&includeChildren=&q=ssrs+OR+reporting+services&redirect=search%2fsearch&sort=relevance&type=question+OR+idea+OR+kbentry+OR+answer+OR+topic+OR+user)
diff --git a/docs/reporting-services/tutorial-format-text-report-builder.md b/docs/reporting-services/tutorial-format-text-report-builder.md
@@ -358,4 +358,4 @@ There are many ways to format text in Report Builder. [Tutorial: Creating a Free
 [Formatting Report Items](../reporting-services/report-design/formatting-report-items-report-builder-and-ssrs.md)  
 [Report Builder in SQL Server](../reporting-services/report-builder/report-builder-in-sql-server-2016.md)  
 
-More questions? [Try asking the Reporting Services forum](https://go.microsoft.com/fwlink/?LinkId=620231)
+More questions? [Try asking the Reporting Services forum](/answers/search.html?c=&f=&includeChildren=&q=ssrs+OR+reporting+services&redirect=search%2fsearch&sort=relevance&type=question+OR+idea+OR+kbentry+OR+answer+OR+topic+OR+user)
diff --git a/docs/reporting-services/web-portal-ssrs-native-mode.md b/docs/reporting-services/web-portal-ssrs-native-mode.md
@@ -114,4 +114,4 @@ Enter a search term, and see everything you can access. The results are categori
 [Planning for Reporting Services Browser Support](../reporting-services/browser-support-for-reporting-services-and-power-view.md)  
 [Reporting Services Features supported by the Editions of SQL Server](../reporting-services/reporting-services-features-supported-by-the-editions-of-sql-server-2016.md)  
 
-More questions? [Try the Reporting Services forum](https://go.microsoft.com/fwlink/?LinkId=620231)
+More questions? [Try the Reporting Services forum](/answers/search.html?c=&f=&includeChildren=&q=ssrs+OR+reporting+services&redirect=search%2fsearch&sort=relevance&type=question+OR+idea+OR+kbentry+OR+answer+OR+topic+OR+user)
diff --git a/docs/reporting-services/what-s-new-in-sql-server-reporting-services-ssrs.md b/docs/reporting-services/what-s-new-in-sql-server-reporting-services-ssrs.md
@@ -246,4 +246,4 @@ The new release of SSDT includes the project templates for [!INCLUDE[ssRSCurrent
 [Upgrade and Migrate Reporting Services](../reporting-services/install-windows/upgrade-and-migrate-reporting-services.md)  
 [Reporting Services](../reporting-services/create-deploy-and-manage-mobile-and-paginated-reports.md)  
 
-More questions? [Try asking the Reporting Services forum](https://go.microsoft.com/fwlink/?LinkId=620231)
+More questions? [Try asking the Reporting Services forum](/answers/search.html?c=&f=&includeChildren=&q=ssrs+OR+reporting+services&redirect=search%2fsearch&sort=relevance&type=question+OR+idea+OR+kbentry+OR+answer+OR+topic+OR+user)
diff --git a/docs/reporting-services/work-with-shared-datasets-web-portal.md b/docs/reporting-services/work-with-shared-datasets-web-portal.md
@@ -100,4 +100,4 @@ Once you are done, you can select **Create Cache Refresh Plan**.
   
 You can then **Edit** or **Delete** plans that are listed. The **New From Existing** option is enabled when one, and only one, cache refresh plan is selected. This option will create a new refresh plan which is copied from the original plan. The cache refresh plan page opens pre-populated with details from the plan that was selected. You can then modify the refresh plan options and save the plan with a new description.  
 
-More questions? [Try asking the Reporting Services forum](https://go.microsoft.com/fwlink/?LinkId=620231)
+More questions? [Try asking the Reporting Services forum](/answers/search.html?c=&f=&includeChildren=&q=ssrs+OR+reporting+services&redirect=search%2fsearch&sort=relevance&type=question+OR+idea+OR+kbentry+OR+answer+OR+topic+OR+user)
diff --git a/docs/reporting-services/working-with-kpis-in-reporting-services.md b/docs/reporting-services/working-with-kpis-in-reporting-services.md
@@ -122,4 +122,4 @@ To refresh the KPI, you will need to configure a caching for the shared dataset.
 [Web portal](../reporting-services/web-portal-ssrs-native-mode.md)  
 [Work with Shared Datasets](../reporting-services/work-with-shared-datasets-web-portal.md)
 
-More questions? [Try asking the Reporting Services forum](https://go.microsoft.com/fwlink/?LinkId=620231)
+More questions? [Try asking the Reporting Services forum](/answers/search.html?c=&f=&includeChildren=&q=ssrs+OR+reporting+services&redirect=search%2fsearch&sort=relevance&type=question+OR+idea+OR+kbentry+OR+answer+OR+topic+OR+user)
diff --git a/docs/reporting-services/working-with-paginated-reports-web-portal.md b/docs/reporting-services/working-with-paginated-reports-web-portal.md
@@ -190,4 +190,4 @@ Select to change how security is defined for the current item.
 [Web portal](../reporting-services/web-portal-ssrs-native-mode.md)  
 [Work with Shared Datasets](../reporting-services/work-with-shared-datasets-web-portal.md)
 
-More questions? [Try asking the Reporting Services forum](https://go.microsoft.com/fwlink/?LinkId=620231)
+More questions? [Try asking the Reporting Services forum](/answers/search.html?c=&f=&includeChildren=&q=ssrs+OR+reporting+services&redirect=search%2fsearch&sort=relevance&type=question+OR+idea+OR+kbentry+OR+answer+OR+topic+OR+user)
diff --git a/docs/reporting-services/working-with-snapshots-web-portal.md b/docs/reporting-services/working-with-snapshots-web-portal.md
@@ -73,4 +73,4 @@ Selecting this will copy a report snapshot that you generate based on report exe
 [Working with paginated reports](working-with-paginated-reports-web-portal.md)  
 [Work with Shared Datasets](../reporting-services/work-with-shared-datasets-web-portal.md)
 
-More questions? [Try asking the Reporting Services forum](https://go.microsoft.com/fwlink/?LinkId=620231)
+More questions? [Try asking the Reporting Services forum](/answers/search.html?c=&f=&includeChildren=&q=ssrs+OR+reporting+services&redirect=search%2fsearch&sort=relevance&type=question+OR+idea+OR+kbentry+OR+answer+OR+topic+OR+user)
diff --git a/docs/reporting-services/working-with-subscriptions-web-portal.md b/docs/reporting-services/working-with-subscriptions-web-portal.md
@@ -90,4 +90,4 @@ After the query has been created, you can then assign values to the required fie
 [Working with paginated reports](working-with-paginated-reports-web-portal.md)  
 [Work with Shared Datasets](../reporting-services/work-with-shared-datasets-web-portal.md)
 
-More questions? [Try asking the Reporting Services forum](https://go.microsoft.com/fwlink/?LinkId=620231)
+More questions? [Try asking the Reporting Services forum](/answers/search.html?c=&f=&includeChildren=&q=ssrs+OR+reporting+services&redirect=search%2fsearch&sort=relevance&type=question+OR+idea+OR+kbentry+OR+answer+OR+topic+OR+user)
diff --git a/docs/sql-server/index.yml b/docs/sql-server/index.yml
@@ -187,7 +187,7 @@ landingContent:
       - text: Database Tuning Advisor 
         url: ../relational-databases/performance/database-engine-tuning-advisor.md
       - text: In-memory OLTP
-        url: ../relational-databases/in-memory-oltp/in-memory-oltp-in-memory-optimization.md
+        url: ../relational-databases/in-memory-oltp/overview-and-usage-scenarios.md
     - linkListType: concept
       links:
       - text: Cardinality estimation
diff --git a/docs/t-sql/functions/objectproperty-transact-sql.md b/docs/t-sql/functions/objectproperty-transact-sql.md
@@ -147,7 +147,7 @@ OBJECTPROPERTY ( id , property )
 |TableInsertTriggerCount|Table|Table has the specified number of INSERT triggers.<br /><br /> >0 = The number of INSERT triggers.|  
 |TableIsFake|Table|Table is not real. It is materialized internally on demand by the [!INCLUDE[ssDEnoversion](../../includes/ssdenoversion-md.md)].<br /><br /> 1 = True<br /><br /> 0 = False|  
 |TableIsLockedOnBulkLoad|Table|Table is locked due to a **bcp** or BULK INSERT job.<br /><br /> 1 = True<br /><br /> 0 = False|  
-|TableIsMemoryOptimized|Table|**Applies to**: [!INCLUDE[ssSQL14](../../includes/sssql14-md.md)] and later.<br /><br /> Table is memory optimized<br /><br /> 1 = True<br /><br /> 0 = False<br /><br /> Base data type: **int**<br /><br /> For more information, see [In-Memory OLTP &#40;In-Memory Optimization&#41;](../../relational-databases/in-memory-oltp/in-memory-oltp-in-memory-optimization.md).|  
+|TableIsMemoryOptimized|Table|**Applies to**: [!INCLUDE[ssSQL14](../../includes/sssql14-md.md)] and later.<br /><br /> Table is memory optimized<br /><br /> 1 = True<br /><br /> 0 = False<br /><br /> Base data type: **int**<br /><br /> For more information, see [In-Memory OLTP &#40;In-Memory Optimization&#41;](../../relational-databases/in-memory-oltp/overview-and-usage-scenarios.md).|  
 |TableIsPinned|Table|Table is pinned to be held in the data cache.<br /><br /> 0 = False<br /><br /> This feature is not supported in [!INCLUDE[ssVersion2005](../../includes/ssversion2005-md.md)] and later.|  
 |TableTextInRowLimit|Table|Maximum bytes allowed for text in row.<br /><br /> 0 if text in row option is not set.|  
 |TableUpdateTrigger|Table|Table has an UPDATE trigger.<br /><br /> > 1 = ID of first trigger with the specified type.|  
@@ -250,5 +250,3 @@ GO
  [TYPEPROPERTY &#40;Transact-SQL&#41;](../../t-sql/functions/typeproperty-transact-sql.md)   
  [sys.objects &#40;Transact-SQL&#41;](../../relational-databases/system-catalog-views/sys-objects-transact-sql.md)  
   
-  
-
diff --git a/docs/t-sql/functions/objectpropertyex-transact-sql.md b/docs/t-sql/functions/objectpropertyex-transact-sql.md
@@ -151,7 +151,7 @@ OBJECTPROPERTYEX ( id , property )
 |TableInsertTriggerCount|Table|The table has the specified number of INSERT triggers.<br /><br /> >0 = The number of INSERT triggers.<br /><br /> Base data type: **int**|  
 |TableIsFake|Table|Table is not real. It is materialized internally on demand by the [!INCLUDE[ssDE](../../includes/ssde-md.md)].<br /><br /> 1 = True<br /><br /> 0 = False<br /><br /> Base data type: **int**|  
 |TableIsLockedOnBulkLoad|Table|Table is locked because a **bcp** or BULK INSERT job.<br /><br /> 1 = True<br /><br /> 0 = False<br /><br /> Base data type: **int**|  
-|TableIsMemoryOptimized|Table|**Applies to**: [!INCLUDE[ssSQL14](../../includes/sssql14-md.md)] and later.<br /><br /> Table is memory optimized<br /><br /> 1 = True<br /><br /> 0 = False<br /><br /> Base data type: **int**<br /><br /> For more information, see [In-Memory OLTP &#40;In-Memory Optimization&#41;](../../relational-databases/in-memory-oltp/in-memory-oltp-in-memory-optimization.md).|  
+|TableIsMemoryOptimized|Table|**Applies to**: [!INCLUDE[ssSQL14](../../includes/sssql14-md.md)] and later.<br /><br /> Table is memory optimized<br /><br /> 1 = True<br /><br /> 0 = False<br /><br /> Base data type: **int**<br /><br /> For more information, see [In-Memory OLTP &#40;In-Memory Optimization&#41;](../../relational-databases/in-memory-oltp/overview-and-usage-scenarios.md).|  
 |TableIsPinned|Table|Table is pinned to be held in the data cache.<br /><br /> 0 = False<br /><br /> This feature is not supported in [!INCLUDE[ssVersion2005](../../includes/ssversion2005-md.md)] and later versions.|  
 |TableTextInRowLimit|Table|Table has text in row option set.<br /><br /> > 0 = Maximum bytes allowed for text in row.<br /><br /> 0 = text in row option is not set.<br /><br /> Base data type: **int**|  
 |TableUpdateTrigger|Table|Table has an UPDATE trigger.<br /><br /> > 1 = ID of first trigger with the specified type.<br /><br /> Base data type: **int**|  
@@ -259,5 +259,3 @@ U
  [ALTER AUTHORIZATION &#40;Transact-SQL&#41;](../../t-sql/statements/alter-authorization-transact-sql.md)   
  [TYPEPROPERTY &#40;Transact-SQL&#41;](../../t-sql/functions/typeproperty-transact-sql.md)  
   
-  
-
diff --git a/docs/t-sql/statements/alter-database-transact-sql-file-and-filegroup-options.md b/docs/t-sql/statements/alter-database-transact-sql-file-and-filegroup-options.md
@@ -290,7 +290,7 @@ CONTAINS MEMORY_OPTIMIZED_DATA
 
 **Applies to**: [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] ( [!INCLUDE[ssSQL14](../../includes/sssql14-md.md)] and later)
 
-Specifies that the filegroup stores memory optimized data in the file system. For more information, see [In-Memory OLTP - In-Memory Optimization](../../relational-databases/in-memory-oltp/in-memory-oltp-in-memory-optimization.md). Only one `MEMORY_OPTIMIZED_DATA` filegroup is allowed per database. For creating memory optimized tables, the filegroup cannot be empty. There must be at least one file. *filegroup_name* refers to a path. The path up to the last folder must exist, and the last folder must not exist.
+Specifies that the filegroup stores memory optimized data in the file system. For more information, see [In-Memory OLTP - In-Memory Optimization](../../relational-databases/in-memory-oltp/overview-and-usage-scenarios.md). Only one `MEMORY_OPTIMIZED_DATA` filegroup is allowed per database. For creating memory optimized tables, the filegroup cannot be empty. There must be at least one file. *filegroup_name* refers to a path. The path up to the last folder must exist, and the last folder must not exist.
 
 REMOVE FILEGROUP *filegroup_name*
 Removes a filegroup from the database. The filegroup cannot be removed unless it is empty. Remove all files from the filegroup first. For more information, see "REMOVE FILE *logical_file_name*," earlier in this topic.
@@ -1109,4 +1109,4 @@ GO
 - [DBCC SHRINKFILE](../../t-sql/database-console-commands/dbcc-shrinkfile-transact-sql.md)
 - [The Memory-Optimized Filegroup](../../relational-databases/in-memory-oltp/the-memory-optimized-filegroup.md)
 
-::: moniker-end
+::: moniker-end
diff --git a/docs/t-sql/statements/create-database-transact-sql.md b/docs/t-sql/statements/create-database-transact-sql.md
@@ -435,7 +435,7 @@ CONTAINS MEMORY_OPTIMIZED_DATA
 
 **Applies to**: [!INCLUDE[ssSQL14](../../includes/sssql14-md.md)] and later
 
-Specifies that the filegroup stores memory_optimized data in the file system. For more information, see [In-Memory OLTP - In-Memory Optimization](../../relational-databases/in-memory-oltp/in-memory-oltp-in-memory-optimization.md). Only one MEMORY_OPTIMIZED_DATA filegroup is allowed per database. For code samples that create a filegroup to store memory-optimized data, see [Creating a Memory-Optimized Table and a Natively Compiled Stored Procedure](../../relational-databases/in-memory-oltp/creating-a-memory-optimized-table-and-a-natively-compiled-stored-procedure.md).
+Specifies that the filegroup stores memory_optimized data in the file system. For more information, see [In-Memory OLTP - In-Memory Optimization](../../relational-databases/in-memory-oltp/overview-and-usage-scenarios.md). Only one MEMORY_OPTIMIZED_DATA filegroup is allowed per database. For code samples that create a filegroup to store memory-optimized data, see [Creating a Memory-Optimized Table and a Natively Compiled Stored Procedure](../../relational-databases/in-memory-oltp/creating-a-memory-optimized-table-and-a-natively-compiled-stored-procedure.md).
 
 DEFAULT
 Specifies the named filegroup is the default filegroup in the database.
@@ -1713,4 +1713,4 @@ CREATE DATABASE mytest
 - [ALTER DATABASE - Analytics Platform System](../../t-sql/statements/alter-database-transact-sql.md?view=aps-pdw-2016-au7&preserve-view=true)
 - [DROP DATABASE](../../t-sql/statements/drop-database-transact-sql.md)
 
-::: moniker-end
+::: moniker-end
diff --git a/docs/t-sql/statements/create-type-transact-sql.md b/docs/t-sql/statements/create-type-transact-sql.md
@@ -289,7 +289,7 @@ Specifies to create an index on the table. This can be a clustered index, or a n
  In user-defined table types, the primary key on computed columns must be PERSISTED and NOT NULL.  
   
 ## Memory-Optimized Table Types  
- Beginning in [!INCLUDE[ssSQL14](../../includes/sssql14-md.md)], processing data in a table type can be done in primary memory, and not on disk. For more information, see [In-Memory OLTP &#40;In-Memory Optimization&#41;](../../relational-databases/in-memory-oltp/in-memory-oltp-in-memory-optimization.md). For code samples showing how to create memory-optimized table types, see [Creating a Memory-Optimized Table and a Natively Compiled Stored Procedure](../../relational-databases/in-memory-oltp/creating-a-memory-optimized-table-and-a-natively-compiled-stored-procedure.md).  
+ Beginning in [!INCLUDE[ssSQL14](../../includes/sssql14-md.md)], processing data in a table type can be done in primary memory, and not on disk. For more information, see [In-Memory OLTP &#40;In-Memory Optimization&#41;](../../relational-databases/in-memory-oltp/overview-and-usage-scenarios.md). For code samples showing how to create memory-optimized table types, see [Creating a Memory-Optimized Table and a Natively Compiled Stored Procedure](../../relational-databases/in-memory-oltp/creating-a-memory-optimized-table-and-a-natively-compiled-stored-procedure.md).  
   
 ## Permissions  
  Requires CREATE TYPE permission in the current database and ALTER permission on *schema_name*. If *schema_name* is not specified, the default name resolution rules for determining the schema for the current user apply. If *assembly_name* is specified, a user must either own the assembly or have REFERENCES permission on it.  
@@ -359,4 +359,4 @@ GO
  [DROP TYPE &#40;Transact-SQL&#41;](../../t-sql/statements/drop-type-transact-sql.md)   
  [EVENTDATA &#40;Transact-SQL&#41;](../../t-sql/functions/eventdata-transact-sql.md)    
  [CLR User-Defined Types](../../relational-databases/clr-integration-database-objects-user-defined-types/clr-user-defined-types.md)     
- [Working with User-Defined Types in SQL Server](../../relational-databases/clr-integration-database-objects-user-defined-types/working-with-user-defined-types-in-sql-server.md)     
+ [Working with User-Defined Types in SQL Server](../../relational-databases/clr-integration-database-objects-user-defined-types/working-with-user-defined-types-in-sql-server.md)

Original file line number	Diff line number	Diff line change
`@@ -100,4 +100,4 @@ Once you are done, you can select Create Cache Refresh Plan.`
`100`	`100`
`101`	`101`	`You can then Edit or Delete plans that are listed. The New From Existing option is enabled when one, and only one, cache refresh plan is selected. This option will create a new refresh plan which is copied from the original plan. The cache refresh plan page opens pre-populated with details from the plan that was selected. You can then modify the refresh plan options and save the plan with a new description.`
`102`	`102`
`103`		`-More questions? [Try asking the Reporting Services forum](https://go.microsoft.com/fwlink/?LinkId=620231)`
	`103`	`+More questions? [Try asking the Reporting Services forum](/answers/search.html?c=&f=&includeChildren=&q=ssrs+OR+reporting+services&redirect=search%2fsearch&sort=relevance&type=question+OR+idea+OR+kbentry+OR+answer+OR+topic+OR+user)`