Goal Progress for Sep 2022
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. Well, clearly I’ve gotten away from my goals. No updates...
2022-10-12
16 reads
Blog Posts
Query Tuning At PASS Data Community Summit
The all new, in-person, PASS Data Community Summit is in just a few weeks. Since I’m shortly going to be publishing a 100% rewritten book on query tuning, I...
2022-10-12 (first published: 2022-09-28)
210 reads
Snowflake Key Pair Authentication
Snowflake does a great job on documenting the key pair process using bash for Linux environments. That’s great, but what if you need to work within a windows environment...
2022-10-12
28 reads
Storytelling with Data – Enertia User Conference 2022
Thank you to everyone who attended my session at the Enertia User Conference in Las Vegas earlier this month! It was a blast meeting everyone, and I can’t wait...
2022-10-12 (first published: 2022-09-30)
180 reads
Daily Coping 11 Oct 2022
Today’s coping tip is to take a small step towards a goal that matters to you. I’ve been working on a coaching certification. I don’t really need it, but...
2022-10-11
11 reads
Query Store at PASS Data Community Summit
While Query Store has been out for quite some time now, released in 2016, there’s still quite a lot of missing understanding of what Query Store can do for...
2022-10-11
8 reads
Snowflake Warehouses
Everyone has heard of scaling up and scaling out compute. Have you ever heard about a term called scaling across? Before Snowflake, I never. Scaling up and down is...
2022-10-11
19 reads
Check Every Metric
Recently, a person asked about the costs differences in an execution plan, referencing them as if they were performance measures. The key to understanding performance is to check every...
2022-10-10
16 reads
Daily Coping 10 Oct 2022
Today’s coping tip is to write down three things you can look forward to in the next month. Easy. Visiting my daughter. I’m heading up this weekend to watch...
2022-10-10
11 reads
Scary Scalar Functions - Part Four: Your Environment
Scary Scalar Functions series overview
Part One: Parallelism
Part Two: Performance
Part Three: The Cure
Part Four: Your Environment
Foreword
In the previous posts, we have learned why Scalar Functions (UDFs) are bad for parallelism...
2022-10-10 (first published: 2022-10-02)
623 reads
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
The Goldilocks problem – Materialized Views
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
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...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
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