Selecting Top N Rows from Excel Source
Excel is a significant source of data in most enterprises. Therefore there is a large amount of Excel work being...
2010-02-20
273 reads
Blog Posts
SSAS Query Processing and Performance Tuning
Any of us can work with some simple MDX queries and get them to do what we want, but in...
2010-02-20
295 reads
Testing Security in SSAS
Security in SSAS is a simple yet powerful application of windows integrated security. MDX adds extra power to this by...
2010-02-20
335 reads
Using MDX to work with the File System
There are sometimes some cool things you can do with a language that is not really it’s primary focus. T-SQL...
2010-02-20
400 reads
Why don’t lookup columns appear in no match output?
I often get asked when we are discussing loading dimension tables in SSIS, why the key columns from the table...
2010-02-20
355 reads
Bikes for Almost Grownups
Ran across this in Make Magazine, http://www.bigkidbike.com/, these are totally custom bikes, with names like Bigger Wheel, Lizard, and Kitten....
2010-02-19
551 reads
Feedback from Connect : Allow Snapshot Backups
I posted a note to allow snapshots to be backed up in SQL Server. The inability to do so, and...
2010-02-19
1,480 reads
On Ethics
I was having a conversation recently with a friend and former co-worker of mine. He's bounced around here and there,...
2010-02-19
798 reads
Playing With SQL Azure Data Synch
Microsoft has provided a free tool that allows you to easily create a SQL Azure database, and then synchronize the...
2010-02-19
1,578 reads
Reporting Services Switch Function
Recently a client requested to create a Reporting Services expression that emulated the CASE WHEN statement from T-SQL. The expression...
2010-02-19
4,291 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