Data Mining Part 37: The Data Mining query transformation task
This new chapter will show you how to work with the SSIS Data Mining Query Transformation Task
2016-04-14
2,546 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
Data Mining Part 36: Verifying the accuracy of the model
In this new chapter we will show how to verify the accuracy of the mining models.
2016-02-29
1,563 reads
Data Mining Part 35: Text Mining using the term extraction tool
The following article will show how to extract terms occurrence from a SQL table.
2016-02-22
3,054 reads
Data Mining Part 34: Preparing for a certification exam
In this article we will talk about the Microsoft certifications related to Data Mining.
2015-12-24
2,872 reads
Data Mining Part 33: The Performance counters
In this new article, we will explain how to use the Performance Counter to measure performance and activity in Microsoft Data Mining
2015-11-26
1,620 reads
Data Mining Part 33: The Performance counters
In this new article, we will explain how to use the Performance Counter to measure performance and activity in Microsoft Data Mining
2015-11-26
1,492 reads
Data Mining Part 32:The Microsoft Data Mining Enemies
In this chapter, we will talk about the competition of Data Mining
2015-10-08
3,008 reads
Data Mining Part 32:The Microsoft Data Mining Enemies
In this chapter, we will talk about the competition of Data Mining
2015-10-08
2,919 reads
Data Mining Part 31: DMX functions
In this chapter, we will learn how to use some DMX functions in our mining models.
2015-08-13
2,213 reads
Data Mining Part 31: DMX functions
In this chapter, we will learn how to use some DMX functions in our mining models.
2015-08-13
2,023 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