Skip to content

Commit 0ea3fcf

Browse files
author
JiayueHu
committed
resolve conflicts from master 2
2 parents b57042d + 8963fc2 commit 0ea3fcf

116 files changed

Lines changed: 1940 additions & 1489 deletions

File tree

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎docs/2014/analysis-services/data-mining-algorithms-sql-server-data-mining-add-ins.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -37,7 +37,7 @@ manager: craigg
3737
|Microsoft Decision Trees algorithm|Identify previously unknown relationships between various elements of your data to better inform your decisions, or find the factors that lead to specific outcomes.<br /><br /> [http://msdn.microsoft.com/library/ms174923.aspx](http://msdn.microsoft.com/library/ms174923.aspx)|
3838
|Microsoft Linear Regression algorithm|Find a mathematical formula that describes factors that contribute to a numeric outcome.<br /><br /> [http://msdn.microsoft.com/library/ms174824.aspx](http://msdn.microsoft.com/library/ms174824.aspx)|
3939
|Microsoft Logistic Regression algorithm|Identify the factors that contribute to binary outcomes, and learn how to use those to affect results.<br /><br /> [http://msdn.microsoft.com/library/ms174828.aspx](http://msdn.microsoft.com/library/ms174828.aspx)|
40-
|Microsoft Naïve Bayes algorithm|Explore relationships in your data and find those mostly closely correlated with an outcome.<br /><br /> [http://msdn.microsoft.com/en-us/library/ms174806.aspx](http://msdn.microsoft.com/library/ms174806.aspx)|
40+
|Microsoft Naïve Bayes algorithm|Explore relationships in your data and find those mostly closely correlated with an outcome.<br /><br /> [http://msdn.microsoft.com/library/ms174806.aspx](http://msdn.microsoft.com/library/ms174806.aspx)|
4141
|Microsoft Neural Networks algorithm|Find hidden relationships among multiple inputs and even multiple outputs. Use for exploration or for prediction.<br /><br /> [http://msdn.microsoft.com/library/ms174941.aspx](http://msdn.microsoft.com/library/ms174941.aspx)|
4242
|Microsoft Time Series algorithm|Use historical data to forecast future values.<br /><br /> [http://msdn.microsoft.com/library/ms174923.aspx](http://msdn.microsoft.com/library/ms174923.aspx)|
4343

‎docs/2014/analysis-services/data-mining/sql-server-data-mining-add-ins-for-office.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -76,7 +76,7 @@ manager: craigg
7676

7777
- Standard
7878

79-
Depending on the edition of SQL Server Analysis Services that you connect to, some of the advanced algorithms might not be available. For information, see [Features Supported by the Editions of SQL Server 2014](https://msdn.microsoft.com/en-us/library/cc645993.aspx).
79+
Depending on the edition of SQL Server Analysis Services that you connect to, some of the advanced algorithms might not be available. For information, see [Features Supported by the Editions of SQL Server 2014](https://msdn.microsoft.com/library/cc645993.aspx).
8080

8181
For additional help with installation, see this page on the Download Center: [http://www.microsoft.com/download/details.aspx?id=29061](http://www.microsoft.com/download/details.aspx?id=29061)
8282

‎docs/2014/analysis-services/dax-formula-compatibility-in-directquery-mode-ssas-2014.md‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -16,7 +16,7 @@ manager: craigg
1616
# DAX Formula Compatibility in DirectQuery Mode (SSAS 2014)
1717
The Data Analysis Expression language (DAX) can be used to create measures and other custom formulas for use in Analysis Services Tabular models, [!INCLUDE[ssGemini](../includes/ssgemini-md.md)] data models in Excel workbooks, and Power BI Desktop data models. In most respects, the models you create in these environments are identical, and you can use the same measures, relationships, and KPIs, etc. However, if you author an Analysis Services Tabular model and deploy it in DirectQuery mode, there are some restrictions on the formulas that you can use. This topic provides an overview of those differences, lists the functions that are not supported in SQL Server 2014 Analysis Services tabulars model at compatibility level 1100 or 1103 and in DirectQuery mode, and lists the functions that are supported but might return different results.
1818

19-
Within this topic, we use the term *in-memory model* to refer to Tabular models, which are fully hosted in-memory cached data on an Analysis Services server running in Tabular mode. We use *DirectQuery models* to refer to Tabular models that have been authored and/or deployed in DirectQuery mode. For information about DirectQuery mode, see [DirectQuery Mode (SSAS Tabular)](http://msdn.microsoft.com/en-us/45ad2965-05ec-4fb1-a164-d8060b562ea5).
19+
Within this topic, we use the term *in-memory model* to refer to Tabular models, which are fully hosted in-memory cached data on an Analysis Services server running in Tabular mode. We use *DirectQuery models* to refer to Tabular models that have been authored and/or deployed in DirectQuery mode. For information about DirectQuery mode, see [DirectQuery Mode (SSAS Tabular)](http://msdn.microsoft.com/45ad2965-05ec-4fb1-a164-d8060b562ea5).
2020

2121

2222
## <a name="bkmk_SemanticDifferences"></a>Differences between in-memory and DirectQuery mode
@@ -86,7 +86,7 @@ For information about the rules governing casts from string to **datetime** data
8686
Models that use the in-memory data store support a more limited range of text formats for dates than the string formats for dates that are supported by SQL Server. However, DAX supports custom date and time formats.
8787

8888
**Cast from string to other non Boolean values**
89-
When casting from strings to non-Boolean values, DirectQuery mode behaves the same as SQL Server. For more information, see [CAST and CONVERT (Transact-SQL)](http://msdn.microsoft.com/en-us/a87d0850-c670-4720-9ad5-6f5a22343ea8).
89+
When casting from strings to non-Boolean values, DirectQuery mode behaves the same as SQL Server. For more information, see [CAST and CONVERT (Transact-SQL)](http://msdn.microsoft.com/a87d0850-c670-4720-9ad5-6f5a22343ea8).
9090

9191
**Cast from numbers to string not allowed**
9292
EXAMPLE: `CONCATENATE(102,”,345”)`
@@ -259,7 +259,7 @@ In DirectQuery mode, the case of the character that is returned is always exactl
259259

260260
By default, the Latin1_General collation is used, which is case-insensitive but accent-sensitive. Therefore, if there are multiple instances of a text string in lower case, upper case, or mixed case, all instances are considered the same string, and only the first instance of the string is stored in the index. All text functions that operate on stored strings will retrieve the specified portion of the indexed form. Therefore, the example formula would return the same value for the entire column, using the first instance as the input.
261261

262-
[String Storage and Collation in Tabular Models](http://msdn.microsoft.com/en-us/8516f0ad-32ee-4688-a304-e705143642ca)
262+
[String Storage and Collation in Tabular Models](http://msdn.microsoft.com/8516f0ad-32ee-4688-a304-e705143642ca)
263263

264264
This behavior also applies to other text functions, including RIGHT, MID, and so forth.
265265

@@ -500,6 +500,6 @@ LASTDATE
500500
DATEADD
501501

502502
## See also
503-
[DirectQuery Mode (SSAS Tabular)](http://msdn.microsoft.com/en-us/45ad2965-05ec-4fb1-a164-d8060b562ea5)
503+
[DirectQuery Mode (SSAS Tabular)](http://msdn.microsoft.com/45ad2965-05ec-4fb1-a164-d8060b562ea5)
504504

505505

‎docs/2014/analysis-services/tabular-model-programming-compatibility-levels-1050-1103/csdl-annotations-for-business-intelligence-csdlbi.md‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -69,6 +69,7 @@ manager: craigg
6969

7070
For detailed information about individual elements in the CSDLBI annotations, see [Technical Reference for BI Annotations to CSDL](https://docs.microsoft.com/bi-reference/csdl/technical-reference-for-bi-annotations-to-csdl). For information about the core CSDL specification, see the [CSDL v3 Specification](https://msdn.microsoft.com/en-us/data/jj652004) on MSDN.
7171

72+
7273
## See Also
7374
[Understanding the Tabular Object Model](representation/understanding-tabular-object-model-at-levels-1050-through-1103.md)
7475
[CSDLBI Concepts](https://docs.microsoft.com/bi-reference/csdl/csdlbi-concepts)

‎docs/2014/analysis-services/xmla/xml-elements-commands/batch-element-xmla.md‎

Lines changed: 79 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,79 @@
1+
---
2+
title: "Batch Element (XMLA) | Microsoft Docs"
3+
ms.custom: ""
4+
ms.date: "06/13/2017"
5+
ms.prod: "sql-server-2014"
6+
ms.reviewer: ""
7+
ms.technology:
8+
- "analysis-services"
9+
- "docset-sql-devref"
10+
ms.topic: "reference"
11+
api_name:
12+
- "Batch Element"
13+
api_location:
14+
- "http://schemas.microsoft.com/analysisservices/2003/engine"
15+
topic_type:
16+
- "apiref"
17+
f1_keywords:
18+
- "urn:schemas-microsoft-com:xml-analysis#Batch"
19+
- "microsoft.xml.analysis.batch"
20+
- "http://schemas.microsoft.com/analysisservices/2003/engine#Batch"
21+
helpviewer_keywords:
22+
- "Batch command"
23+
ms.assetid: 818f3212-9605-4e34-8623-1154d9fae1f0
24+
author: minewiskan
25+
ms.author: owend
26+
manager: craigg
27+
---
28+
# Batch Element (XMLA)
29+
Performs one or more XML for Analysis (XMLA) commands as a batch operation, either sequentially or in parallel, on an instance of [!INCLUDE[msCoName](../../../includes/msconame-md.md)] [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] [!INCLUDE[ssASnoversion](../../../includes/ssasnoversion-md.md)].
30+
31+
## Syntax
32+
33+
```xml
34+
35+
<Command>
36+
<Batch Transaction="Boolean" ProcessAffectedObjects="Boolean">
37+
<Bindings>...</Bindings>
38+
<DataSource>...</DataSource>
39+
<DataSourceView>...</DataSourceView>
40+
<ErrorConfiguration>...</ErrorConfiguration>
41+
<Parallel>...</Parallel>
42+
<!-- One or more XMLA commands -->
43+
</Batch>
44+
</Command>
45+
```
46+
47+
## Element Characteristics
48+
49+
|Characteristic|Description|
50+
|--------------------|-----------------|
51+
|Data type and length|None|
52+
|Default value|None|
53+
|Cardinality|0-n: Optional element that can occur more than once.|
54+
55+
## Element Relationships
56+
57+
|Relationship|Element|
58+
|------------------|-------------|
59+
|Parent elements|[Command](../xml-elements-properties/command-element-xmla.md)|
60+
|Child elements|[Bindings](../xml-elements-properties/bindings-element-xmla.md), [DataSource](../xml-elements-properties/source-element-xmla.md), [DataSourceView](../xml-elements-properties/datasourceview-element-xmla.md), [ErrorConfiguration](../../scripting/objects/errorconfiguration-element-assl.md), [Parallel](../xml-elements-properties/parallel-element-xmla.md)<br /><br /> One or more of the following XMLA commands: [Alter](alter-element-xmla.md), [Backup](backup-element-xmla.md), [BeginTransaction](begintransaction-element-xmla.md), [ClearCache](clearcache-element-xmla.md), [CommitTransaction](committransaction-element-xmla.md), [Create](create-element-xmla.md), [Delete](delete-element-xmla.md), [DesignAggregations](designaggregations-element-xmla.md), [Drop](drop-element-xmla.md), [Insert](insert-element-xmla.md), [Lock](lock-element-xmla.md), [MergePartitions](mergepartitions-element-xmla.md), [NotifyTableChange](notifytablechange-element-xmla.md), [Process](process-element-xmla.md), [Restore](restore-element-xmla.md), [RollbackTransaction](rollbacktransaction-element-xmla.md), [SetPasswordEncryptionKey](http://msdn.microsoft.com/fb262737-f0f4-4441-985e-3b2a94d00a9e), [Statement](statement-element-xmla.md), [Subscribe](subscribe-element-xmla.md), [Synchronize](synchronize-element-xmla.md), [Unlock](unlock-element-xmla.md), [Update](update-element-xmla.md), [UpdateCells](drop-element-xmla.md)|
61+
62+
## Attributes
63+
64+
|Attribute|Description|
65+
|---------------|-----------------|
66+
|ProcessAffectedObjects|(Optional `Boolean` attribute) Indicates whether all objects that require reprocessing will be processed.<br /><br /> If set to true, the [!INCLUDE[ssASnoversion](../../../includes/ssasnoversion-md.md)] instance processes any objects that require reprocessing as a result of processing an object included in the `Batch` command.<br /><br /> If set to `false`, the [!INCLUDE[ssASnoversion](../../../includes/ssasnoversion-md.md)] instance processes only those objects included in the `Batch` command.|
67+
|Transaction|(Optional `Boolean` attribute) Indicates whether the command included in the `Batch` command are treated as a single transaction or individual transactions.<br /><br /> If set to true, all of the commands included in the `Batch` command are considered a single transaction. If any command fails, the commands executed prior to the failed command are rolled back, and the `Batch` command stops without executing subsequent commands.<br /><br /> If set to `false`, the `Batch` command attempts to execute every command, and commits the results of each command that completes successfully.|
68+
69+
## Remarks
70+
71+
> [!WARNING]
72+
> Command/Execute/Statement is currently not supported in a Batch operation.
73+
74+
For more information about performing batch operations in XMLA, see [Performing Batch Operations &#40;XMLA&#41;](../../multidimensional-models-scripting-language-assl-xmla/performing-batch-operations-xmla.md).
75+
76+
## See Also
77+
[Commands &#40;XMLA&#41;](xml-elements-commands.md)
78+
79+

‎docs/2014/analysis-services/xmla/xml-elements-properties/command-element-xmla.md‎

Lines changed: 115 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,115 @@
1+
---
2+
title: "Command Element (XMLA) | Microsoft Docs"
3+
ms.custom: ""
4+
ms.date: "03/06/2017"
5+
ms.prod: "sql-server-2014"
6+
ms.reviewer: ""
7+
ms.technology:
8+
- "analysis-services"
9+
- "docset-sql-devref"
10+
ms.topic: "reference"
11+
api_name:
12+
- "Command Element"
13+
api_location:
14+
- "http://schemas.microsoft.com/analysisservices/2003/engine"
15+
topic_type:
16+
- "apiref"
17+
f1_keywords:
18+
- "microsoft.xml.analysis.command"
19+
- "Command"
20+
- "urn:schemas-microsoft-com:xml-analysis#Command"
21+
- "http://schemas.microsoft.com/analysisservices/2003/engine#Command"
22+
helpviewer_keywords:
23+
- "Command element"
24+
ms.assetid: 9abc14df-7cbe-46bc-ba0f-f0691c19afad
25+
author: minewiskan
26+
ms.author: owend
27+
manager: craigg
28+
---
29+
# Command Element (XMLA)
30+
Contains the command to be executed by the [Execute](../xml-elements-methods-execute.md) method.
31+
32+
## Syntax
33+
34+
```xml
35+
36+
<Execute>
37+
...
38+
<Command>
39+
<Alter>...</Alter>
40+
<!-- or -->
41+
<Backup>...</Backup>
42+
<!-- or -->
43+
<Batch>...</Batch>
44+
<!-- or -->
45+
<BeginTransaction>...</BeginTransaction>
46+
<!-- or -->
47+
<Cancel>...</Cancel>
48+
<!-- or -->
49+
<ClearCache>...</ClearCache>
50+
<!-- or -->
51+
<CommitTransaction>...</CommitTransaction>
52+
<!-- or -->
53+
<Create>...</Create>
54+
<!-- or -->
55+
<Delete>...</Delete>
56+
<!-- or -->
57+
<DesignAggregations>...</DesignAggregations>
58+
<!-- or -->
59+
<Drop>...</Drop>
60+
<!-- or -->
61+
<Insert>...</Insert>
62+
<!-- or -->
63+
<Lock>...</Lock>
64+
<!-- or -->
65+
<MergePartitions>...</MergePartitions>
66+
<!-- or -->
67+
<NotifyTableChange>...</NotifyTableChange>
68+
<!-- or -->
69+
<Process>...</Process>
70+
<!-- or -->
71+
<Restore>...</Restore>
72+
<!-- or -->
73+
<RollbackTransaction>...</RollbackTransaction>
74+
<!-- or -->
75+
<SetPasswordEncryptionKey>...</SetPasswordEncryptionKey>
76+
<!-- or -->
77+
<Statement>...</Statement>
78+
<!-- or -->
79+
<Subscribe>...</Subscribe>
80+
<!-- or -->
81+
<Synchronize>...</Synchronize>
82+
<!-- or -->
83+
<Unlock>...</Unlock>
84+
<!-- or -->
85+
<Update>...</Update>
86+
<!-- or -->
87+
<UpdateCells>...</UpdateCells>
88+
</Command>
89+
...
90+
</Execute>
91+
```
92+
93+
## Element Characteristics
94+
95+
|Characteristic|Description|
96+
|--------------------|-----------------|
97+
|Data type and length|None|
98+
|Default value|None|
99+
|Cardinality|1-1: Required element that occurs once and only once.|
100+
101+
## Element Relationships
102+
103+
|Relationship|Element|
104+
|------------------|-------------|
105+
|Parent elements|[Execute](../xml-elements-methods-execute.md)|
106+
|Child elements|[Alter](../xml-elements-commands/alter-element-xmla.md), [Backup](../xml-elements-commands/backup-element-xmla.md), [Batch](../xml-elements-commands/batch-element-xmla.md), [BeginTransaction](../xml-elements-commands/begintransaction-element-xmla.md), [Cancel](../xml-elements-commands/cancel-element-xmla.md), [ClearCache](../xml-elements-commands/clearcache-element-xmla.md), [CommitTransaction](../xml-elements-commands/committransaction-element-xmla.md), [Create](../xml-elements-commands/create-element-xmla.md), [Delete](../xml-elements-commands/delete-element-xmla.md), [DesignAggregations](../xml-elements-commands/designaggregations-element-xmla.md), [Drop](../xml-elements-commands/drop-element-xmla.md), [Insert](../xml-elements-commands/insert-element-xmla.md), [Lock](../xml-elements-commands/lock-element-xmla.md), [MergePartitions](../xml-elements-commands/mergepartitions-element-xmla.md), [NotifyTableChange](../xml-elements-commands/notifytablechange-element-xmla.md), [Process](../xml-elements-commands/process-element-xmla.md), [Restore](../xml-elements-commands/restore-element-xmla.md), [RollbackTransaction](../xml-elements-commands/rollbacktransaction-element-xmla.md), [SetPasswordEncryptionKey](http://msdn.microsoft.com/fb262737-f0f4-4441-985e-3b2a94d00a9e), [Statement](../xml-elements-commands/statement-element-xmla.md), [Subscribe](../xml-elements-commands/subscribe-element-xmla.md), [Synchronize](../xml-elements-commands/synchronize-element-xmla.md), [Unlock](../xml-elements-commands/unlock-element-xmla.md), [Update](../xml-elements-commands/update-element-xmla.md), [UpdateCells](../xml-elements-commands/drop-element-xmla.md)|
107+
108+
## Remarks
109+
The `Command` element is used by the `Execute` method to relay commands to a data source. While the XML for Analysis (XMLA) 1.1 Specification supports only the `Statement` command, [!INCLUDE[msCoName](../../../includes/msconame-md.md)] [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] [!INCLUDE[ssASnoversion](../../../includes/ssasnoversion-md.md)] supports many new XMLA commands. For more information about the XMLA command supported by [!INCLUDE[ssASnoversion](../../../includes/ssasnoversion-md.md)], see [Commands &#40;XMLA&#41;](../xml-elements-commands/xml-elements-commands.md).
110+
111+
## See Also
112+
[XML Data Types &#40;XMLA&#41;](../xml-data-types/xml-data-types-xmla.md)
113+
[Properties &#40;XMLA&#41;](xml-elements-properties.md)
114+
115+

‎docs/2014/database-engine/extensions-to-adventureworks-to-demonstrate-in-memory-oltp.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -17,7 +17,7 @@ manager: craigg
1717
This sample showcases the new [!INCLUDE[hek_2](../includes/hek-2-md.md)] feature, which is part of [!INCLUDE[ssSQL14](../includes/sssql14-md.md)]. It shows the new memory-optimized tables and natively-compiled stored procedures, and can be used to demonstrate performance benefits of [!INCLUDE[hek_2](../includes/hek-2-md.md)].
1818

1919
> [!NOTE]
20-
> To view this topic for SQL Server 2016, see [Extensions to AdventureWorks to Demonstrate In-Memory OLTP](https://msdn.microsoft.com/en-US/library/mt465764.aspx)
20+
> To view this topic for SQL Server 2016, see [Extensions to AdventureWorks to Demonstrate In-Memory OLTP](https://msdn.microsoft.com/library/mt465764.aspx)
2121
2222
The sample migrates 5 tables in the AdventureWorks database to memory-optimized, and it includes a demo workload for sales order processing. You can use this demo workload to see the performance benefit of using [!INCLUDE[hek_2](../includes/hek-2-md.md)] on your server.
2323

‎docs/2014/database-engine/sql-server-managed-backup-to-windows-azure-retention-and-storage-settings.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -116,7 +116,7 @@ manager: craigg
116116
>
117117
> For more information on creating a certificate for encryption, see the Create a Backup Certificate step in [Create an Encrypted Backup](../relational-databases/backup-restore/create-an-encrypted-backup.md).
118118
119-
For more information on this stored procedure, see [smart_admin.set_db_backup &#40;Transact-SQL&#41;](https://msdn.microsoft.com/en-us/library/dn451013(v=sql.120).aspx)
119+
For more information on this stored procedure, see [smart_admin.set_db_backup &#40;Transact-SQL&#41;](https://msdn.microsoft.com/library/dn451013(v=sql.120).aspx)
120120
121121
To review the configuration settings for a database use the following query:
122122

‎docs/2014/master-data-services/create-a-date-attribute-master-data-services.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -81,7 +81,7 @@ manager: craigg
8181

8282
After you enter a row with the above values in the mdm.tblList table, the “dd/MM/yyyy hh:mm:ss tt” mask will be available in the Input mask list box. You can then select that mask to display the date and time in a datetime attribute column of an entity in the MDS Explorer.
8383

84-
The Input Mask is a custom .NET DateTime format string. For more information, see [Custom Date and Time Format Strings](https://msdn.microsoft.com/en-us/library/8kb3ddd4\(v=vs.110\).aspx)
84+
The Input Mask is a custom .NET DateTime format string. For more information, see [Custom Date and Time Format Strings](https://msdn.microsoft.com/library/8kb3ddd4\(v=vs.110\).aspx)
8585

8686
## See Also
8787
[Attributes &#40;Master Data Services&#41;](../../2014/master-data-services/attributes-master-data-services.md)

0 commit comments

Comments
 (0)