Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Data Mining Query Tasks and How-tos

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

The ability to create queries is critical if you are to make use of your data mining models. This section provides links to examples of how to create queries against a data mining model by using the tools provided in SQL Server Management Studio and SQL Server Data Tools (SSDT). If you need more information about what a data mining query is, or the different types of queries you can create, see Data Mining Queries.

The Prediction Query Builder is provided in both SQL Server Data Tools (SSDT) and SQL Server Management Studio as a way of graphically building queries against data mining models. The following topics explain how you can select a model, specify a data source, customize the predictions, and save output.

In addition to using the Prediction Query Builder, you can type a query directly into SQL Server Management Studio by using DMX or by using XMLA. You can also build prediction queries programmatically and send them to an Analysis Services server. The following topics provide more information about how to create and work with prediction queries outside of the Prediction Query Builder.

Create a Singleton Prediction Query from a Template

Describes how to use the tools in SQL Server Management Studio to build and run a prediction query.

Create a Singleton Prediction Query from a Template

Describes how to use the templates that are provided in SQL Server Management Studio to add parameters to a prediction query.

Change the Time-out Value for Data Mining Queries

Describes how to set properties on the server that control behavior related to data mining queries.

Create a Content Query on a Mining Model

Describes how to create queries that return detailed information that is stored in the mining model by using the data mining schema rowsets.

Create a Data Mining Query by Using XML/A

Describes how to create a query against mining model content by using the XMLA templates in SQL Server Management Studio.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft