DBA.Sleep(8hrs)
I have been pondering recently what helps me to sleep at night. Or, conversely, what prevents me from sleeping at...
2010-02-17
1,331 reads
Blog Posts
Development Lifecycle Deployment SSAS, SSRS, SSIS
Many companies have a very rigid development lifecycle for all products or solutions they develop. Deploying to each of these...
2010-02-17
3,928 reads
Development Lifecycle Deployment SSAS, SSRS, SSIS
Many companies have a very rigid development lifecycle for all products or solutions they develop.Deploying to each of these environments...
2010-02-17
876 reads
Do I have to snatch the pebble?
Attending the Microsoft Certified Master (MCM) program in March
This is the most excited I've been since I heard that Alice...
2010-02-17
812 reads
First International speaker for our User Group
I am a nervous wreck today. Tomorrow we will have the first International speaker for our user group. Jimmy may...
2010-02-17
737 reads
Join the PASS Summit 2010 Program Committee
Just in case you didn’t see it, we’re looking for volunteers for the 2010 program committee – the team that evaluates...
2010-02-17
754 reads
Keyboard Clash
The SQLServerCentral servers are in the UK, and installed by UK personnel at Rackspace. We recently switched servers to Rackspace,...
2010-02-17
959 reads
Mirroring a Large Number of Databases in a Single SQL Server Instance
Microsoft SQLCAT team members Sanjay Mishra and Prem Mehra have published a new Technical Note called Mirroring a Large Number...
2010-02-17
980 reads
MVP Summit Impressions From Day 1
Well, today was the opening day of the 2010 MVP Global Summit in Bellevue, WA. There were a few “side...
2010-02-17
640 reads
Presenting At SQL Saturday #33 - Charlotte
Just a quick note to let you know that I'm presenting two sessions at SQL Saturday #33 in Charlotte on...
2010-02-17
742 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...
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...
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