eReading – Lending Books
I sent this to Barnes and Noble, as well as Random House recently after the much vaunted “lending” technology in...
2010-02-11
319 reads
Blog Posts
Growing the Pool of SQL Server Speakers
In a nutshell, I’m interested in growing and diversifying the pool of speakers that focus on SQL Server. You might...
2010-02-11
989 reads
ISNULL() VS. COALESCE()
There are a lot of arguments about which of these to use. In my opinion, they both have their place. ...
2010-02-11
9,064 reads
POTW Webcast with Kevin Kline
Today I'll be tagging along with Kevin Kline for the Quest Pain of the Week webcast. We'll be talking about...
2010-02-11
955 reads
SQL Server Trace Events
I answered a forum post the other day over on SSC on the differences between the trace events stmtcompleted and...
2010-02-11
2,967 reads
A Tale Of Two Execution (Updated)
Update: Scroll to the bottom for more information added after originally posting.
Earlier this week a coworker asked me for help...
2010-02-10
715 reads
February OPASS Meeting Recap
Introduction
Last night we had our February OPASS meeting with Ron Dameron (@RonDBA) presenting on Database Hardening using PowerShell. We broadcast...
2010-02-10
406 reads
Negotiating Salary for a New Job
Slightly off topic, but I’m adding this one to the Modern Resume blog since I think it’s something to be...
2010-02-10
484 reads
Notes from the February 2010 oPASS Meeting
Really rainy in Orlando today, traffic is horrible. We had a higher than usual number of RSVP’s for the meeting,...
2010-02-10
478 reads
SQLSaturday #43 Announced!
Greg Larsen is hosting SQLSaturday in Redmond, WA again this year, this time on June 12, 2009. Call for speakers...
2010-02-10
588 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...
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