Access Analysis Services via T-SQL?
It occurred to me the other day that it might be interesting to manage aggregates in an SQL Server database...
2010-03-22
864 reads
Blog Posts
Be Responsible in your blogging and posting
I have been awarded the MVP award from Microsoft a few years in a row and it’s an honor, but...
2010-03-22
671 reads
Don't Throw Something New In At Production Deployment
This post comes from a conversation I had with a developer last week as well as my experiences over the...
2010-03-22
1,817 reads
Free Events – It’s All About Expectations
Isn’t free enough? If you go to a free event do you have a right to complain? Or, if you...
2010-03-22
977 reads
More Thoughts on Certification
After a great response to my last post on Certification, I need to post my thoughts on 70-450 PRO: Designing,...
2010-03-22
580 reads
PASS BI Virtual Chapter
Did you know that PASS has virtual chapters, allowing members to participate in virtual meetings that are geographically agnostic? One...
2010-03-22
1,221 reads
SP_SPACEUSED & SP_MSTABLESPACE
Take a look two SP inside the sys Procedure in SQL Server 2008 (included also in the SQL Server 2005),...
2010-03-22
4,540 reads
SSWUG Ultimate vConference Discount Code
The SSWUG Ultimate Virtual Conference is coming up on April 7, 8, and 9th. This is three days of very...
2010-03-22
833 reads
Why UniqueIdentifier is a Bad Choice for a Clustered Index in SQL Server
I had a question today about why it was “bad” to use a UniqueIdentifier as the data type for a...
2010-03-22
9,357 reads
I’ve Moved and So Should You
After blogging on Live Spaces for a couple of years, I’ve made the difficult decision to move to my own...
2010-03-21
522 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