SQL SEO OKR - update long titles

stevestein · stevestein · commit 297f540f77c3 · 2019-12-16T22:57:21.000-08:00
diff --git a/docs/t-sql/functions/date-and-time-data-types-and-functions-transact-sql.md b/docs/t-sql/functions/date-and-time-data-types-and-functions-transact-sql.md
@@ -1,6 +1,8 @@
 ---
-title: "Date and Time Data Types and Functions (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+title: "Date and Time Data Types and Functions"
+description: Links to Date and Time data types and functions articles.
+titleSuffix: SQL Server (Transact-SQL)
+ms.custom: "seo-lt-2019"
 ms.date: "09/01/2017"
 ms.prod: sql
 ms.prod_service: "sql-database"
diff --git a/docs/t-sql/language-elements/bitwise-exclusive-or-equals-transact-sql.md b/docs/t-sql/language-elements/bitwise-exclusive-or-equals-transact-sql.md
@@ -1,6 +1,8 @@
 ---
-title: "^= (Bitwise Exclusive OR Assignment) (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+title: "^= Bitwise Exclusive OR Assignment"
+description: Bitwise exclusive OR operation between two integer values, and sets a value to the result of the operation.
+titleSuffix: SQL Server (Transact-SQL)
+ms.custom: "seo-lt-2019"
 ms.date: "01/10/2017"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/language-elements/bitwise-or-equals-transact-sql.md b/docs/t-sql/language-elements/bitwise-or-equals-transact-sql.md
@@ -1,6 +1,6 @@
 ---
 title: "|= (Bitwise OR)"
-titleSuffix: Transact-SQL
+titleSuffix: SQL Server (Transact-SQL)
 ms.custom: "seo-lt-2019"
 ms.date: "01/10/2017"
 ms.prod: sql
diff --git a/docs/t-sql/language-elements/kill-query-notification-subscription-transact-sql.md b/docs/t-sql/language-elements/kill-query-notification-subscription-transact-sql.md
@@ -1,6 +1,8 @@
 ---
-title: "KILL QUERY NOTIFICATION SUBSCRIPTION (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+title: "KILL QUERY NOTIFICATION SUBSCRIPTION"
+description: Remove query notification subscriptions from an instance. This statement can remove a specific subscription or all subscriptions.
+titleSuffix: SQL Server (Transact-SQL)
+ms.custom: "seo-lt-2019"
 ms.date: "07/27/2017"
 ms.prod: sql
 ms.prod_service: "sql-database"
diff --git a/docs/t-sql/language-elements/string-concatenation-equal-transact-sql.md b/docs/t-sql/language-elements/string-concatenation-equal-transact-sql.md
@@ -1,6 +1,8 @@
 ---
-title: "+= (String Concatenation and Assignment) (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+title: "+= String concatenation"
+description: Concatenate two strings and set the string to the result of the operation.
+titleSuffix: SQL Server (Transact-SQL)
+ms.custom: "seo-lt-2019"
 ms.date: "12/07/2016"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/language-elements/wildcard-character-s-not-to-match-transact-sql.md b/docs/t-sql/language-elements/wildcard-character-s-not-to-match-transact-sql.md
@@ -1,7 +1,7 @@
 ---
 title: "[^] Wildcard to exclude characters"
 description: "T-SQL wildcard for characters not to match"
-titleSuffix: Transact-SQL
+titleSuffix: SQL Server (Transact-SQL)
 ms.custom: "seo-lt-2019"
 ms.date: "12/06/2016"
 ms.prod: sql
diff --git a/docs/t-sql/language-elements/wildcard-character-s-to-match-transact-sql.md b/docs/t-sql/language-elements/wildcard-character-s-to-match-transact-sql.md
@@ -1,6 +1,8 @@
 ---
-title: "[ ] (Wildcard - Character(s) to Match) (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+title: "[ ] Wildcard to match characters"
+description: Use a wildcard to match one or more characters.
+titleSuffix: SQL Server (Transact-SQL)
+ms.custom: "seo-lt-2019"
 ms.date: "12/06/2016"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/statements/alter-database-scoped-configuration-transact-sql.md b/docs/t-sql/statements/alter-database-scoped-configuration-transact-sql.md
@@ -1,6 +1,8 @@
 ---
-title: "ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+title: "ALTER DATABASE SCOPED CONFIGURATION"
+description: Enable several database configuration settings at the individual database level.
+titleSuffix: SQL Server (Transact-SQL)
+ms.custom: "seo-lt-2019"
 ms.date: 10/31/2019
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database"
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
@@ -1,7 +1,7 @@
 ---
 title: "ALTER DATABASE File and Filegroups"
 description: Update a database's files and filegroups using Transact-SQL.
-titleSuffix: Transact-SQL
+titleSuffix: SQL Server (Transact-SQL)
 ms.custom: "seo-lt-2019"
 ms.date: "02/21/2019"
 ms.prod: sql
diff --git a/docs/t-sql/statements/create-database-audit-specification-transact-sql.md b/docs/t-sql/statements/create-database-audit-specification-transact-sql.md
@@ -1,6 +1,8 @@
 ---
-title: "CREATE DATABASE AUDIT SPECIFICATION (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+title: "CREATE DATABASE AUDIT SPECIFICATION"
+description: Create a database audit specification object using the SQL Server audit feature.
+titleSuffix: SQL Server (Transact-SQL)
+ms.custom: "seo-lt-2019"
 ms.date: "04/04/2017"
 ms.prod: sql
 ms.prod_service: "sql-database"
diff --git a/docs/t-sql/statements/deny-availability-group-permissions-transact-sql.md b/docs/t-sql/statements/deny-availability-group-permissions-transact-sql.md
@@ -1,6 +1,8 @@
 ---
-title: "DENY Availability Group Permissions (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+title: "DENY Availability Group Permissions"
+description: Deny permissions on an Always On availability group.
+titleSuffix: SQL Server (Transact-SQL)
+ms.custom: "seo-lt-2019"
 ms.date: "05/15/2017"
 ms.prod: sql
 ms.prod_service: "sql-database"
diff --git a/docs/t-sql/statements/deny-database-principal-permissions-transact-sql.md b/docs/t-sql/statements/deny-database-principal-permissions-transact-sql.md
@@ -1,6 +1,8 @@
 ---
-title: "DENY Database Principal Permissions (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+title: "DENY Database Principal Permissions"
+description: Deny permissions on a database user, database role, or application role.
+titleSuffix: SQL Server (Transact-SQL)
+ms.custom: "seo-lt-2019"
 ms.date: "05/15/2017"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database"
diff --git a/docs/t-sql/statements/deny-search-property-list-permissions-transact-sql.md b/docs/t-sql/statements/deny-search-property-list-permissions-transact-sql.md
@@ -1,6 +1,8 @@
 ---
-title: "DENY Search Property List Permissions (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+title: "DENY Search Property List Permissions"
+description: Deny permissions on a search property list.
+titleSuffix: SQL Server (Transact-SQL)
+ms.custom: "seo-lt-2019"
 ms.date: "06/10/2016"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/statements/deny-xml-schema-collection-permissions-transact-sql.md b/docs/t-sql/statements/deny-xml-schema-collection-permissions-transact-sql.md
@@ -1,6 +1,8 @@
 ---
-title: "DENY XML Schema Collection Permissions (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+title: "DENY XML Schema Collection Permissions"
+description: Deny permissions on an XML schema collection.
+titleSuffix: SQL Server (Transact-SQL)
+ms.custom: "seo-lt-2019"
 ms.date: "06/09/2017"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database"
diff --git a/docs/t-sql/statements/grant-availability-group-permissions-transact-sql.md b/docs/t-sql/statements/grant-availability-group-permissions-transact-sql.md
@@ -1,6 +1,8 @@
 ---
-title: "GRANT Availability Group Permissions (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+title: "GRANT Availability Group Permissions"
+description: Grant permissions on an Always On availability group.
+titleSuffix: SQL Server (Transact-SQL)
+ms.custom: "seo-lt-2019"
 ms.date: "06/12/2017"
 ms.prod: sql
 ms.prod_service: "sql-database"
diff --git a/docs/t-sql/statements/grant-database-principal-permissions-transact-sql.md b/docs/t-sql/statements/grant-database-principal-permissions-transact-sql.md
@@ -1,6 +1,8 @@
 ---
-title: "GRANT Database Principal Permissions (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+title: "GRANT Database Principal Permissions"
+description: Grant permissions on a database user, database role, or application role.
+titleSuffix: SQL Server (Transact-SQL)
+ms.custom: "seo-lt-2019"
 ms.date: "03/12/2017"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/statements/grant-search-property-list-permissions-transact-sql.md b/docs/t-sql/statements/grant-search-property-list-permissions-transact-sql.md
@@ -1,6 +1,8 @@
 ---
-title: "GRANT Search Property List Permissions (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+title: "GRANT Search Property List Permissions"
+description: Grant permissions on a search property list.
+titleSuffix: SQL Server (Transact-SQL)
+ms.custom: "seo-lt-2019"
 ms.date: "07/26/2017"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
diff --git a/docs/t-sql/statements/grant-xml-schema-collection-permissions-transact-sql.md b/docs/t-sql/statements/grant-xml-schema-collection-permissions-transact-sql.md
@@ -1,6 +1,8 @@
 ---
-title: "GRANT XML Schema Collection Permissions (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+title: "GRANT XML Schema Collection Permissions"
+description: Grants permissions on an XML schema collection.
+titleSuffix: SQL Server (Transact-SQL)
+ms.custom: "seo-lt-2019"
 ms.date: "08/10/2017"
 ms.prod: sql
 ms.prod_service: "sql-database"
diff --git a/docs/t-sql/statements/revoke-availability-group-permissions-transact-sql.md b/docs/t-sql/statements/revoke-availability-group-permissions-transact-sql.md
@@ -1,6 +1,8 @@
 ---
-title: "REVOKE Availability Group Permissions (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+title: "REVOKE Availability Group Permissions"
+description: Revoke permissions on an Always On availability group.
+titleSuffix: SQL Server (Transact-SQL)
+ms.custom: "seo-lt-2019"
 ms.date: "08/10/2017"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database"
diff --git a/docs/t-sql/statements/revoke-database-principal-permissions-transact-sql.md b/docs/t-sql/statements/revoke-database-principal-permissions-transact-sql.md
@@ -1,6 +1,8 @@
 ---
-title: "REVOKE Database Principal Permissions (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+title: "REVOKE Database Principal Permissions"
+description: Revoke permissions on a database user, database role, or application role.
+titleSuffix: SQL Server (Transact-SQL)
+ms.custom: "seo-lt-2019"
 ms.date: "08/10/2017"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database"
diff --git a/docs/t-sql/statements/revoke-search-property-list-permissions-transact-sql.md b/docs/t-sql/statements/revoke-search-property-list-permissions-transact-sql.md
@@ -1,6 +1,8 @@
 ---
-title: "REVOKE Search Property List Permissions (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+title: "REVOKE Search Property List Permissions"
+description: Revoke permissions on a search property list.
+titleSuffix: SQL Server (Transact-SQL)
+ms.custom: "seo-lt-2019"
 ms.date: "06/10/2016"
 ms.prod: sql
 ms.prod_service: "sql-database"
diff --git a/docs/t-sql/statements/revoke-server-principal-permissions-transact-sql.md b/docs/t-sql/statements/revoke-server-principal-permissions-transact-sql.md
@@ -1,6 +1,8 @@
 ---
-title: "REVOKE Server Principal Permissions (Transact-SQL) | Microsoft Docs"
-ms.custom: ""
+title: "REVOKE Server Principal Permissions"
+description: Revoke permissions on a SQL Server login.
+titleSuffix: SQL Server (Transact-SQL)
+ms.custom: "seo-lt-2019"
 ms.date: "08/10/2017"
 ms.prod: sql
 ms.prod_service: "sql-database"
