I am thrilled to announce the launch of a new education initiative called SQLibrium. For years, I’ve traveled the world educating technical audiences on deep-dive topics around how data and...
2021-02-10 (first published: 2021-02-02)
263 reads
(2021-Jan-31) Working on DIY home projects is always fun, choosing the right tools: whether I handle paperhanging scissors to cut my wallpapers, or create an opening and trim my drywall...
2021-02-10 (first published: 2021-02-01)
259 reads
Some years ago, I wrote about what it means to be “professional” (and that it doesn’t mean having to wear a suit and tie). Recently a conversation broke out...
2021-02-10
172 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-02-09
22 reads
Recently I needed to take a look at all of the SQL Server Agent Jobs and their Jobs Steps for a customer. Specifically, I needed to review all of...
2021-02-09 (first published: 2021-02-03)
703 reads
It’s common that users only have access to certain folders in an Azure Data Lake Storage container. These permissions are provided not through Azure RBAC (role-based access control) roles...
2021-02-09 (first published: 2021-02-04)
199 reads
Story time: A few months ago I was in a meeting where we were all asked how we could take on a complex, but very necessary task. As they...
2021-02-09
10 reads
It’s time for the fourth post in my series about performing regular server reviews. In the first post, we took a look at setting up your local environment. The...
2021-02-09
31 reads
Figma — one of the most popular and fastest growing digital design tools today — was recently voted “the most exciting design tool of 2021.” In many organizations, a...
2021-02-09
11 reads
I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at something called the Ascending Key Problem which can badly...
2021-02-09
184 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