SQL Server Data Mining Programmability
Learn more about the new APIs for data mining in SQL Server 2005, and get an introduction to several common development scenarios.
2009-04-24
2,532 reads
Learn more about the new APIs for data mining in SQL Server 2005, and get an introduction to several common development scenarios.
2009-04-24
2,532 reads
2009-04-03
2,630 reads
Customer interactions reveal important trends and patterns that can help a company design a website that effectively communicates and markets its products and services.
2008-12-24
1,509 reads
Get an overview of typical data mining problems and the tools and models that are available in SQL Server 2005 for solving these problems.
2008-05-30
3,571 reads
2008-04-02
2,786 reads
This tip shows you how you can apply the cross-validation feature in the upcoming SQL Server 2008 release to estimate if the training set size is sufficient for a given model.
2008-03-05
1,371 reads
Get a high-level overview of the benefits of the extensibility framework in SQL Server 2005 Analysis Services that allows independent software developers to easily integrate new data mining algorithms into the product.
2007-12-31
1,647 reads
This tip provides insight into the inner workings of the Microsoft Naive Bayes algorithm, showing how the algorithm computes the score used to filter out correlations.
2007-11-30
1,620 reads
This tip explores a DMX extension introduced in SQL Server 2005 SP2 that can be used to render lift reports directly in Reporting Services.
2007-05-24
3,491 reads
This video sample shows how the clustering algorithm can be used to automatically validate data.
2006-11-08
2,184 reads
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
I’m excited to announce the release of a new open-source project that fully automates...
Comments posted to this topic are about the item Server-Level Table sizes
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers