Where Do You Look on the Internet for SQL Server Jobs?
I recently had a SQL Server DBA write to me that they were going to be laid off, and they...
2010-02-24
685 reads
Blog Posts
Adventures in Webinar Presentations
Over the past several years, I have given 2-3 live web presentations a year, and I have always found them...
2010-02-23
647 reads
Cross Database RI Issues
I had an issue with a user recently. Actually it has been going on over a few weeks, due to...
2010-02-23
962 reads
Database Weekly Week
I used to build the Database Weekly newsletter and write the editorial every week. It was a chore, and it’s...
2010-02-23
800 reads
Day 1 - Pragmatic Works Webinar Series
WOW – what a great turnout for our webinar series today. We had two sessions on Monday, looking for some great...
2010-02-23
585 reads
Find Ultimate Parent at any Level From Any Level
Recently I got a forum question that I thought would be a good blog entry for others to share.
The question...
2010-02-23
870 reads
IntelliSense Slow to Refresh
IntelliSense in SQL Server 2008 can sometimes not be very intelligent. It’s there to help you can sometimes cause more...
2010-02-23
7,496 reads
MVP Summit Review
I was lucky enough to attend the MVP Summit held last week in Redmond and Bellevue. I attended the Summit...
2010-02-23
852 reads
Quest POTW Webcast on SQL Injection Now Available
Back a couple of weeks ago I had the privilege of participating in a Pain of the Week webcast with Kevin...
2010-02-23
1,376 reads
Self-Managed Oracle Databases – Good or Bad ?!
Should we as DBAs be worried that we will become surplus to requirements if Oracle continues to enhance its capabilities to deliver a self-managing...
2010-02-23
384 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...
How We Handled a Vendor Retry That Loaded Twice in Snowflake
Comments posted to this topic are about the item How We Handled a Vendor...
Cognitive Coverage
Comments posted to this topic are about the item Cognitive Coverage
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