I absolutely love Query Store and the ability it provides to force a plan is amazing. However, there are a lot of little gotchas in this functionality. I just...
2020-03-09 (first published: 2020-03-02)
416 reads
One of the requirements that springs up around data stores – regardless of if they are relational, not relational, cloud based or some other variety is (unsurprisingly) the need...
2020-03-08
236 reads
The notes! Attendance was the speaker dinner was great! Always nice to have a lot of people there. During the day logistics all went well, though it’s still a...
2020-03-08
28 reads
Thanks for joining us at the first annual SQLSaturday Baton Rouge Business Intelligence yesterday, put on by the Baton Rouge Analytics and Intelligence Network (#GOBRAIN!), an official chapter of...
2020-03-08
23 reads
Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With more than 15 years of experiences in the field of databases, business warehouses and development,...
2020-03-06 (first published: 2020-02-28)
155 reads
Sometimes a swift kick in the rear is needed to become motivated. Recently, I was the recipient of the business end of a boot and it drove me to...
2020-03-06
13 reads
I deliberately didn’t set any goals at the start of 2020 since I was taking six weeks off for a sabbatical. That’s done, and it’s time to look forward....
2020-03-06 (first published: 2020-03-02)
479 reads
Every ETL pipeline is only ever as reliable as the data that the upstream system provides. It is inevitable that assumptions you make about the data you are provided...
2020-03-06
8 reads
Every ETL pipeline is only ever as reliable as the data that the upstream system provides. It is inevitable that assumptions you make about the data you are provided...
2020-03-06
25 reads
Last week (as I write this), Kevin Hill (blog | twitter) released the first episode of his new podcast Data Bits. I enjoyed listening to it and said “hey...
2020-03-05
15 reads
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item How We Handled a Vendor...
Comments posted to this topic are about the item Cognitive Coverage
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