It’s been a while, but I’m finally participating in T-SQL Tuesday again! This month Erik Darling (blog|twitter) is hosting. Ever ... Continue reading
2023-07-26 (first published: 2023-07-11)
366 reads
The invitation this month is from Erik Darling, and it’s a neat one. I like this thought, asking us to find code that impressed us or made us feel...
2023-07-26 (first published: 2023-07-11)
448 reads
Good morning dear reader, Long time no talk. It has been a jam-packed and chaotic first half of 2023 for my family and me. The first quarter of the...
2023-07-25
56 reads
Pain Point: Something bad happened and you need to restore a SQL Server database. Pain Point you didn’t know you had: The backup files are all corrupt due a...
2023-07-25
308 reads
Actually, this is a change for many products and software that connects to SQL Server. Updated drivers require us to now decide to trust the server certificate. I opened...
2023-07-24
133 reads
The early bird pricing for the PASS Data Community Summit ends this week, on Jul 26. After that, there is a bump, so let you boss know this is...
2023-07-24
35 reads
What will be much easier with Microsoft Fabric?
Microsoft Fabric is built on a foundation of Software as a Service (SaaS), which takes simplicity and integration to a whole new...
2023-07-24 (first published: 2023-07-11)
401 reads
Just to reiterate what's in the title of this post, what I mean is that the CLUSTERED COLUMNSTORE indexes are not ordered, while NONCLUSTERED COLUMNSTORE created indexes are on...
2023-07-24 (first published: 2023-07-05)
539 reads
I am so happy to announce that I have joined the team at Fortified Data. I have just completed my first week (well, four days) and I feel like...
2023-07-23
40 reads
Looking forward to #jambalaya at #SQLSatBR on July 29! Register today: sqlsatbr.comI hope to see as many people as possible that weekend, I'll be there at the Friday night...
2023-07-22 (first published: 2023-07-21)
32 reads
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
By way of background, a while back I did video called “My New Favourite...
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
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