PASS SQLRally Dallas 2012 Pre-Con: How to Perform a SQL Server Health Check
If you are attending the PASS SQLRally this May in Dallas, I will be presenting a one day preconference session...
2012-02-29
2,518 reads
If you are attending the PASS SQLRally this May in Dallas, I will be presenting a one day preconference session...
2012-02-29
2,518 reads
Later this year, a new book by author Grant Fritchey, called Learn SQL Server in a Month of Lunches, will...
2012-02-15
1,668 reads
As we have done for the last several years, SQLServerCentral.com will be offering its own track at SQL Server Connections...
2012-02-01 (first published: 2012-01-31)
2,500 reads
Sometimes its fun to think of what career you might have chosen if you hadn’t become a DBA. With this...
2012-02-01
828 reads
Reprinted from my editorial in Database Weekly.
I know a lot of DBAs who make SQL Server the focus of their...
2012-01-20
889 reads
DBAs always tend to face many difficulties in maintaining a healthy work-life balance. Brad McGehee encourages some debate on the best strategies to make this work, in the face of long working hours, and the desire to contribute fully to the SQL Server community.
2012-01-16
502 reads
Recently, I was doing some testing/playing around on a particular database on my home test servers. After I was done,...
2012-01-06
804 reads
2012 is already upon us and I have been busy working on my travel schedule for this year. It is...
2012-01-04
677 reads
Although SQL Server 2012 coming out this year, I think some of us are still trying to catch up with...
2012-01-04
687 reads
This editorial was originally published in Database Weekly.
The November 2011 edition of Popular Science magazine was devoted to data. In...
2011-12-14
997 reads
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
In all recent versions of the database you can call DBMS_UTILITY.EXPAND_SQL_TEXT to get the...
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
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