Microsoft SQL Server 2005

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Working with named queries

    A named query is a virtual view on your data source that allows you to change the data you are mining in SQL Server without making changes to your original data. 

  • Working with named calculations

    SQL Server named calculations allow you to mine derived information in your data without having to change your source data. Get an overview of named calculations. 

  • Creating SQL Server data mining reports

    SQL Server Reporting Services allows you to create custom data mining reports containing text and graphics that can be distributed via HTML, email or in print or Microsoft Office documents. 

  • Using the Mining Model Prediction Builder

    The Mining Model Prediction Builder pane in SQL Server 2005 allows you to build and edit prediction queries, view the results and save the results back to a table. 

  • Creating data mining objects: Data sources

    To perform data mining, you must indicate and describe your source data and then create mining structures and models. 

  • Using the Mining Accuracy Chart

    Once data models are processed, you need to be able to explore, query and compare them. Learn how to use Analysis Services to understand your data mining efforts. 

  • BI Dev Studio offline mode and immediate mode

    BI Dev Studio works in two operating modes, each with its own data mining advantages and drawbacks. 

  • Using SQL Server 2005 data mining

    Data warehouses and data marts hold a wealth of valuable information. Learn how to tap into that information with Chapter 3 of Data Mining with SQL Server 2005. This chapter will review the Analysis Services toolset and provide techniques to create a... 

  • Processing: Training data models on SQL Server

    Data mining processes all data models in a structure in parallel on a single data read by creating a compressed cache of the data. Outlined here are several processing options. 

  • Using the SQL Server Data Mining Designer

    The SQL Server Data Mining Designer contains the facilities for editing, browsing, querying, and comparing data models. Learn how to use the Data Mining Designer.