{
"metadata": {
"kernelspec": {
"name": "SQL",
"display_name": "SQL",
"language": "sql"
},
"language_info": {
"name": "sql",
"version": ""
}
},
"nbformat_minor": 2,
"nbformat": 4,
"cells": [
{
"cell_type": "markdown",
"source": [
"# **SQL Modernization What The Hack**\n",
"\n",
"## **Challenge 2 - Intelligent Query Processing**"
],
"metadata": {
"azdata_cell_guid": "ec95d7d2-f56c-40e2-a3c9-745878dd7436"
}
},
{
"cell_type": "markdown",
"source": [
"## Introduction\n",
"\n",
"Wide World Importers has been motivated by the migration to the cloud to better understand database performance and requires your team's expertise. They are hoping to understand how to better evaluate problem spots, and take advantage of features within SQL Server 2019+ that might help. Additionally, as part of their modernization effort, they feel this an ideal time to leverage Notebooks."
],
"metadata": {
"azdata_cell_guid": "6ac20070-6c6f-4193-828f-bd7e3e13b1e5"
}
},
{
"cell_type": "markdown",
"source": [
"## Step 0 - Configuration\n",
"\n",
"To isolate the difference in performance the team is seeing, all of these tests should be performed on the team's \"on-premises\" server -- we will switch database compatability appropriately to illustrate how the query performs on SQL 2016 vs SQL 2019, and the actual execution time is easier to compare as the hardware is identical. Further, it will be easier to visualize the performance changes by using Query Store. This may also be tested between on premises and the migrated server, but there may be other performance characteristics that impact performance."
],
"metadata": {
"azdata_cell_guid": "ca019cc0-3328-4e58-9405-54ff4159d2ad"
}
},
{
"cell_type": "markdown",
"source": [
"## Step 1 - Create the test stored procedure\n",
"\n",
"To demonstrate one of the performance anomalies WWI's developers are seeing, they've created the following code snippet that is similar to what is used in some of their analytical queries. \n",
"\n",
"This procedure uses a table variable populated from a user table and then joins it with a user table to provide output. T-SQL functions like COUNT and SUM are often seen in analytic queries. Note: In this example the TOP 1 T-SQL syntax is used so that the procedure only produces 1 row. This is only done to make the output easier to read in this workshop since this procedure will be executed multiple times. Normal execution of this procedure may not include TOP.\n",
"\n",
"There is also a query to bring all pages from Sales.Invoices into buffer pool cache to ensure the comparisons are fair."
],
"metadata": {
"azdata_cell_guid": "1b38a047-4fd5-422f-a6ec-c8fe6dbe1dbe"
}
},
{
"cell_type": "code",
"source": [
"USE WideWorldImporters\r\n",
"GO\r\n",
"CREATE or ALTER PROCEDURE [Sales].[CustomerProfits]\r\n",
"AS\r\n",
"BEGIN\r\n",
"-- Declare the table variable\r\n",
"DECLARE @ilines TABLE\r\n",
"(\t[InvoiceLineID] [int] NOT NULL primary key,\r\n",
"\t[InvoiceID] [int] NOT NULL,\r\n",
"\t[StockItemID] [int] NOT NULL,\r\n",
"\t[Description] [nvarchar](100) NOT NULL,\r\n",
"\t[PackageTypeID] [int] NOT NULL,\r\n",
"\t[Quantity] [int] NOT NULL,\r\n",
"\t[UnitPrice] [decimal](18, 2) NULL,\r\n",
"\t[TaxRate] [decimal](18, 3) NOT NULL,\r\n",
"\t[TaxAmount] [decimal](18, 2) NOT NULL,\r\n",
"\t[LineProfit] [decimal](18, 2) NOT NULL,\r\n",
"\t[ExtendedPrice] [decimal](18, 2) NOT NULL,\r\n",
"\t[LastEditedBy] [int] NOT NULL,\r\n",
"\t[LastEditedWhen] [datetime2](7) NOT NULL\r\n",
")\r\n",
"\r\n",
"-- Insert all the rows from InvoiceLines into the table variable\r\n",
"INSERT INTO @ilines SELECT * FROM Sales.InvoiceLines\r\n",
"\r\n",
"-- Find my total profile by customer\r\n",
"SELECT TOP 1 COUNT(i.CustomerID) as customer_count, SUM(il.LineProfit) as total_profit\r\n",
"FROM Sales.Invoices i\r\n",
"INNER JOIN @ilines il\r\n",
"ON i.InvoiceID = il.InvoiceID\r\n",
"GROUP By i.CustomerID\r\n",
"END\r\n",
"GO\r\n",
"-- Pull these pages into cache to make the comparison fair based on a warm buffer pool cache\r\n",
"SELECT COUNT(*) FROM Sales.Invoices"
],
"metadata": {
"azdata_cell_guid": "bbdad878-6acd-44a1-aa1d-8ecbf9fcd987"
},
"outputs": [
{
"output_type": "display_data",
"data": {
"text/html": "Commands completed successfully."
},
"metadata": {}
},
{
"output_type": "display_data",
"data": {
"text/html": "Commands completed successfully."
},
"metadata": {}
},
{
"output_type": "display_data",
"data": {
"text/html": "(1 row affected)"
},
"metadata": {}
},
{
"output_type": "display_data",
"data": {
"text/html": "Total execution time: 00:00:00.057"
},
"metadata": {}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 0,
"batchId": 2,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "(No column name)",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 1,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "(No column name)"
}
]
},
"data": [
{
"0": "70510"
}
]
},
"text/html": [
"
",
"(No column name) |
",
"70510 |
",
"
"
]
}
}
],
"execution_count": 1
},
{
"cell_type": "markdown",
"source": [
"## Step 2 - Run the stored procedure with database compatibility of 130\n",
"\n",
"To begin, the script will ensure the database is in a compatibility mode of 130 (SQL 2016). The script also turns off rowcount messages to be returned to the client to reduce network traffic for this test. Then the script executes the stored procedure. Notice the syntax of **GO 25**. This is a client tool tip that says to run the batch 25 times (avoids having to construct a loop).\n",
"\n",
"When you click Play to run the script look for these messages on the total elapsted time (your time may vary)\n",
"\n",
"```\n",
"Beginning execution loop\n",
"Batch execution completed 25 times...\n",
"Total execution time: 00:00:40.3520665\n",
"```"
],
"metadata": {
"azdata_cell_guid": "c259adbd-8826-4849-9eb8-d18c01f8bfa1"
}
},
{
"cell_type": "code",
"source": [
"USE master\r\n",
"GO\r\n",
"ALTER DATABASE wideworldimporters SET compatibility_level = 130\r\n",
"GO\r\n",
"USE WideWorldImporters\r\n",
"GO\r\n",
"SET NOCOUNT ON\r\n",
"GO\r\n",
"EXEC [Sales].[CustomerProfits]\r\n",
"GO 25\r\n",
"SET NOCOUNT OFF\r\n",
"GO"
],
"metadata": {
"azdata_cell_guid": "fd3712da-895a-4f8a-b5d4-07baedcbaf8c",
"tags": []
},
"outputs": [
{
"output_type": "display_data",
"data": {
"text/html": "Commands completed successfully."
},
"metadata": {}
},
{
"output_type": "display_data",
"data": {
"text/html": "Commands completed successfully."
},
"metadata": {}
},
{
"output_type": "display_data",
"data": {
"text/html": "Commands completed successfully."
},
"metadata": {}
},
{
"output_type": "display_data",
"data": {
"text/html": "Commands completed successfully."
},
"metadata": {}
},
{
"output_type": "display_data",
"data": {
"text/html": "Beginning execution loop"
},
"metadata": {}
},
{
"output_type": "display_data",
"data": {
"text/html": "Batch execution completed 25 times..."
},
"metadata": {}
},
{
"output_type": "display_data",
"data": {
"text/html": "Commands completed successfully."
},
"metadata": {}
},
{
"output_type": "display_data",
"data": {
"text/html": "Total execution time: 00:00:27.513"
},
"metadata": {}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 0,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 1,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 2,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 3,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 4,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 5,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 6,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 7,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 8,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 9,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 10,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 11,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 12,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 13,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 14,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 15,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 16,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 17,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 18,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 19,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 20,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 21,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 22,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 23,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 24,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 2,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
}
],
"execution_count": 2
},
{
"cell_type": "markdown",
"source": [
"## Step 3 - Run the stored procedure with database compatibility of 150\n",
"\n",
"Now let's run the same exact test but with database compatibility of 150. You will not make any changes to the stored procedure.\n",
"\n",
"The script should execute far faster than before. \n",
"\n",
"When you click Play to run the script look for these messages on the total elapsted time (your time may vary)\n",
"\n",
"```\n",
"Beginning execution loop\n",
"Batch execution completed 25 times...\n",
"Total execution time: 00:00:10.9975239\n",
"```"
],
"metadata": {
"azdata_cell_guid": "b97aea3d-07ae-4b4b-b118-847b6390448b"
}
},
{
"cell_type": "code",
"source": [
"USE master\r\n",
"GO\r\n",
"ALTER DATABASE wideworldimporters SET compatibility_level = 150\r\n",
"GO\r\n",
"USE WideWorldImporters\r\n",
"GO\r\n",
"SET NOCOUNT ON\r\n",
"GO\r\n",
"EXEC [Sales].[CustomerProfits]\r\n",
"GO 25\r\n",
"SET NOCOUNT OFF\r\n",
"GO"
],
"metadata": {
"azdata_cell_guid": "fecbf9a7-ea1b-445d-ac3c-b84ca0b60e80"
},
"outputs": [
{
"output_type": "display_data",
"data": {
"text/html": "Commands completed successfully."
},
"metadata": {}
},
{
"output_type": "display_data",
"data": {
"text/html": "Commands completed successfully."
},
"metadata": {}
},
{
"output_type": "display_data",
"data": {
"text/html": "Commands completed successfully."
},
"metadata": {}
},
{
"output_type": "display_data",
"data": {
"text/html": "Commands completed successfully."
},
"metadata": {}
},
{
"output_type": "display_data",
"data": {
"text/html": "Beginning execution loop"
},
"metadata": {}
},
{
"output_type": "display_data",
"data": {
"text/html": "Batch execution completed 25 times..."
},
"metadata": {}
},
{
"output_type": "display_data",
"data": {
"text/html": "Commands completed successfully."
},
"metadata": {}
},
{
"output_type": "display_data",
"data": {
"text/html": "Total execution time: 00:00:06.475"
},
"metadata": {}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 0,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 1,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 2,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 3,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 4,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 5,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 6,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 7,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 8,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 9,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 10,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 11,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 12,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 13,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 14,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 15,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 16,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 17,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 18,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 19,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 20,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 21,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 22,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 23,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
},
{
"output_type": "execute_result",
"metadata": {
"resultSet": {
"id": 24,
"batchId": 4,
"rowCount": 1,
"complete": true,
"columnInfo": [
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 8,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "customer_count",
"columnOrdinal": 0,
"columnSize": 4,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 10,
"numericScale": 255,
"udtAssemblyQualifiedName": null,
"dataType": "System.Int32, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "int"
},
{
"isBytes": false,
"isChars": false,
"isSqlVariant": false,
"isUdt": false,
"isXml": false,
"isJson": false,
"sqlDbType": 5,
"isHierarchyId": false,
"isSqlXmlType": false,
"isUnknownType": false,
"isUpdatable": false,
"allowDBNull": true,
"baseCatalogName": null,
"baseColumnName": null,
"baseSchemaName": null,
"baseServerName": null,
"baseTableName": null,
"columnName": "total_profit",
"columnOrdinal": 1,
"columnSize": 17,
"isAliased": null,
"isAutoIncrement": false,
"isExpression": null,
"isHidden": null,
"isIdentity": false,
"isKey": null,
"isLong": false,
"isReadOnly": true,
"isUnique": false,
"numericPrecision": 38,
"numericScale": 2,
"udtAssemblyQualifiedName": null,
"dataType": "System.Decimal, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e",
"dataTypeName": "decimal"
}
],
"specialAction": {
"none": true,
"expectYukonXMLShowPlan": false
}
}
},
"execution_count": 3,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "customer_count"
},
{
"name": "total_profit"
}
]
},
"data": [
{
"0": "406",
"1": "147225.15"
}
]
},
"text/html": [
"",
"customer_count | total_profit |
",
"406 | 147225.15 |
",
"
"
]
}
}
],
"execution_count": 3
},
{
"cell_type": "markdown",
"source": [
"## Evaluation\n",
"\n",
"Compare the total execution time with a compat level of 130 vs 150. Now that we've (hopefully) seen the performance is substantially better on SQL 2019, it's time to analyze why so WWI can learn how to optimize their queries. To complete this exercise, use Query Store to evaluate the different queries. What is different about the execution plans? What accounts for the difference?"
],
"metadata": {
"azdata_cell_guid": "52a917da-ee56-4f51-85ef-3f05443f1d0c"
}
}
]
}