Analytic Functions – PERCENTILE_CONT / PERCENTILE_DISC
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.
Analytic Functions in SQL...
2011-09-22
11,790 reads
A Discussion of SQL Server-Related Topics
Analytic Functions – CUME_DIST / PERCENT_RANK
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.
Analytic Functions in SQL...
2011-09-20
5,446 reads
Presenting Banish RBAR! to Hampton Roads UG
On Wednesday, Sept 21, 2011 at 6:30pm EST, I’ll be presenting Banish RBAR! to the Hampton Roads SQL Server User...
2011-09-19
639 reads
Analytic Functions – FIRST_VALUE / LAST_VALUE
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.
Analytic Functions in SQL...
2011-09-15
4,039 reads
Analytic Functions – LAG / LEAD
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.
Analytic Functions in SQL...
2011-09-13
3,426 reads
Analytic Functions – Overview
?This post is the first post in a series discussing the new Analytic functions in SQL Server “Denali”, CTP3, and...
2011-09-13
992 reads
Presenting Banish RBAR! at Richmond SQL UG
On Thursday, Sept 8, 2011 at 6:30pm EST, I’ll be presenting Banish RBAR! to the Richmond SQL Server User Group....
2011-09-07
691 reads
Presenting at Curacao SQL UG
On Thursday, Sept 1, 2011 at 7:15pm EST, I’ll be presenting via LiveMeeting to the Curacao SQL Server User Group....
2011-08-31
1,664 reads
Running totals in “Denali” CTP3
One of the things that I’m the most excited about in “Denali” CTP3 is the enhancements to the OVER clause....
2011-08-23
791 reads
ORDER BY Clause with clustered index
One thing that I have seen repeatedly is that (too) many people believe that if you have a clustered index...
2011-08-20
1,977 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