Data Mining Part 30: System Views
Sometimes we need to retrieve system information from our data mining models. In this chapter, we will show how to do it using system views.
2015-07-09
2,530 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
Data Mining Part 30: System Views
Sometimes we need to retrieve system information from our data mining models. In this chapter, we will show how to do it using system views.
2015-07-09
2,493 reads
Data Mining Part 29: Programming with C# and AMO
In this article, we will show some debugging tips for working with C# and the AMO code for working with Analysis Services and the Data Mining Models.
2015-06-16
3,000 reads
Data Mining Part 29: Programming with C# and AMO
In this article, we will show some debugging tips for working with C# and the AMO code for working with Analysis Services and the Data Mining Models.
2015-06-16
2,442 reads
Data Mining Part 28: Programming with AMO and VB
In this article we will use VB.NET to connect to our Mining Models.
2015-06-04
4,372 reads
Data Mining Part 28: Programming with AMO and VB
In this article we will use VB.NET to connect to our Mining Models.
2015-06-04
4,159 reads
Data Mining Part 27: Microsoft Data Mining with Cubes
In the chapter 26 we created a cube. Now, we are going to create the Data Mining Model from it.
2015-04-27
3,764 reads
Data Mining Part 27: Microsoft Data Mining with Cubes
In the chapter 26 we created a cube. Now, we are going to create the Data Mining Model from it.
2015-04-27
3,560 reads
Data Mining Part 26: Introduction to Cubes
In this tutorial we will explain what are the SSAS cubes to use them in Data Mining.
2015-04-21
4,399 reads
Data Mining Part 26: Data Mining and Microsoft Azure
This article shows a step by step tutorial to create a virtual machine in 15 min on Windows Azure.
2015-03-12
2,711 reads
Blogs
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
WITH clause gets a 26ai boost!
By way of background, a while back I did video called “My New Favourite...
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
How We Handled a Vendor Retry That Loaded Twice in Snowflake
Comments posted to this topic are about the item How We Handled a Vendor...
Cognitive Coverage
Comments posted to this topic are about the item Cognitive Coverage
Question of the Day
Getting the Average
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers