Merge pull request #27842 from MicrosoftDocs/FromPublicRepo

PhilKang0704 · web-flow · commit d87672b1901f · 2023-07-28T06:17:27.000+08:00
Confirm merge from FromPublicRepo to main to sync with https://github.com/MicrosoftDocs/sql-docs (branch live)
diff --git a/docs/relational-databases/system-catalog-views/sys-query-store-plan-transact-sql.md b/docs/relational-databases/system-catalog-views/sys-query-store-plan-transact-sql.md
@@ -47,8 +47,8 @@ monikerRange: "=azuresqldb-current||>=sql-server-2016||=azure-sqldw-latest||>=sq
 |**initial_compile_start_time**|**datetimeoffset**|Plan compilation statistics.|
 |**last_compile_start_time**|**datetimeoffset**|Plan compilation statistics.|
 |**last_execution_time**|**datetimeoffset**|Last execution time refers to the last end time of the query/plan.|
-|**avg_compile_duration**|**float**|Plan compilation statistics.|
-|**last_compile_duration**|**bigint**|Plan compilation statistics.|
+|**avg_compile_duration**|**float**|Plan compilation statistics, in microseconds. Divide by 1000000 to get seconds.|
+|**last_compile_duration**|**bigint**|Plan compilation statistics, in microseconds. Divide by 1000000 to get seconds.|
 |**plan_forcing_type**|**int**|Plan forcing type.<br /><br />0: NONE<br /><br />1: MANUAL<br /><br />2: AUTO|
 |**plan_forcing_type_desc**|**nvarchar(60)**|Text description of `plan_forcing_type`.<br /><br />NONE: No plan forcing<br /><br />MANUAL: Plan forced by user<br /><br />AUTO: Plan forced by automatic tuning.|
 |**has_compile_replay_script**|bit|**Applies to:** [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] (Starting with [!INCLUDE[sql-server-2022](../../includes/sssql22-md.md)])<BR/><BR/>Indicates whether the plan has an optimization replay script associated with it:<BR/><BR/>0 = No optimization replay script (none or even invalid).<BR/><BR/>1 = optimization replay script recorded. <BR/><BR/>Not applicable to [!INCLUDE [ssazuresynapse_md](../../includes/ssazuresynapse-md.md)].|
@@ -166,4 +166,4 @@ Learn more about Query Store and related concepts in the following articles:
 - [sys.query_store_wait_stats (Transact-SQL)](../../relational-databases/system-catalog-views/sys-query-store-wait-stats-transact-sql.md)
 - [sys.query_store_runtime_stats_interval (Transact-SQL)](../../relational-databases/system-catalog-views/sys-query-store-runtime-stats-interval-transact-sql.md)
 - [Catalog Views (Transact-SQL)](../../relational-databases/system-catalog-views/catalog-views-transact-sql.md)
-- [Query Store Stored Procedures (Transact-SQL)](../../relational-databases/system-stored-procedures/query-store-stored-procedures-transact-sql.md)
+- [Query Store Stored Procedures (Transact-SQL)](../../relational-databases/system-stored-procedures/query-store-stored-procedures-transact-sql.md)
diff --git a/docs/relational-databases/system-catalog-views/sys-query-store-query-text-transact-sql.md b/docs/relational-databases/system-catalog-views/sys-query-store-query-text-transact-sql.md
@@ -28,7 +28,7 @@ monikerRange: "=azuresqldb-current||>=sql-server-2016||=azure-sqldw-latest||>=sq
 |-----------------|---------------|-----------------|  
 |**query_text_id**|**bigint**|Primary key.|  
 |**query_sql_text**|**nvarchar(max)**|SQL text of the query, as provided by the user. Includes whitespaces, hints and comments. Comments and spaces before and after the query text are ignored. Comments and spaces inside text are not ignored.|  
-|**statement_sql_handle**|**vabinary(64)**|SQL handle of the individual query.|  
+|**statement_sql_handle**|**varbinary(64)**|SQL handle of the individual query.|  
 |**is_part_of_encrypted_module**|**bit**|Query text is a part of an encrypted module.<br/>**Note:** Azure Synapse Analytics will always return zero (0).|
 |**has_restricted_text**|**bit**|Query text contains a password or other unmentionable words.<br/>**Note:** Azure Synapse Analytics will always return zero (0).|
   
