Daily Coping 17 Mar 2023
Today’s coping tip is to eat mindfully. Appreciate the taste, texture, and smell of your food. I am not a big foodie. I’ve been to some cool dinners with...
2023-03-17
13 reads
Blog Posts
SQLpassion Live Training about SQL Server Query Tuning Fundamentals
On April 4, 2023 I will run an SQLpassion Live Training about SQL Server Query Tuning Fundamentals. If you have a database driven application which reacts very slowly when...
2023-03-17 (first published: 2023-03-07)
329 reads
Daily Coping 16 Mar 2023
Today’s coping tip is to take three calm breaths at regular intervals during the day. I had to travel recently, crossing time zones and moving between planes, trains, and...
2023-03-16
13 reads
Book Review – SQL Query Design Patterns and Best Practices
Disclaimer: The publisher – Packt – sent me a free copy of the book for the intended purpose of a review. At the time of writing, the book is...
2023-03-15 (first published: 2023-03-05)
520 reads
Daily Coping 15 Mar 2023
Today’s coping tip is to slow down if you find yourself rushing too often. The modern world encourages rushing around. We try to do so many things, get to...
2023-03-15
20 reads
Stellar Repair for MS SQL – Product Review
If you’re experiencing delays and errors while working with SQL Server databases due to corrupt database files, you may feel frustrated and helpless. Fortunately, Stellar Repair for MS SQL...
2023-03-15
54 reads
Tales From The Field Weekly Wrap Up for the Week of 02-27-2023 & Some Changes
Hello Dear Reader! Change is the one constant in life and over here at Tales from the Field we've been hard at work making some changes. Over the last 5...
2023-03-15 (first published: 2023-03-07)
97 reads
Daily Coping 14 Mar 2023
Today’s coping tip is to notice how you speak to yourself and choose to use kind words. I was downtown recently for a few days with my wife, staying...
2023-03-14
12 reads
FIRST Robotics Competition 2023
For the past few years, I have been a mentor for FIRST Lego League and now FIRST Robotics Competition at our school. When I was in high school, I...
2023-03-14
21 reads
JC Bootcamp Stories – Nikola
Od minulého roku jsme spustili náš 4-týdenní Joyful Craftsmen Bootcamp pro budoucí Data Engineers. Jedná se o intenzivní studium přímo u nás v Joyful Craftsmen HUBu, které posouvá datové...
2023-03-14
20 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...
ALAMAT KONTAK BCA KCU PONTIANAK Telp,Cs:08218154393
WA:08218154393 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
ALAMAT KONTAK BCA KCU BALIKPAPAN Telp,Cs:08218154393
WA:08218154393 Jl. Jenderal Sudirman No.139, Klandasan Ilir, Kec. Balikpapan Kota, Kota Balikpapan, Kalimantan Timur...
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