What’s the Difference Between PERCENT_RANK and CUME_DIST?
Learn a bit about the different results you get from the PERCENT_RANK and CUME_DIST aggregate functions.
2019-06-27
12,612 reads
Learn a bit about the different results you get from the PERCENT_RANK and CUME_DIST aggregate functions.
2019-06-27
12,612 reads
2018-01-25
901 reads
Alan Burstein discusses a better performning alternative to PERCENT_RANK that works on SQL Server versions 2005+
2018-01-05 (first published: 2016-06-07)
12,943 reads
Percentiles give meaning to measurements by telling you the percentage of the population being measured who get higher or lower values. They are now easier to calculate in SQL, and are useful for reporting; but are the new analytic functions faster and more efficient than the older methods? Dwain Camps demonstrates, and investigates their relative performance.
2015-05-27
7,757 reads
I was sick of changing context in Azure Data Studio while cleaning up things...
By Zikato
The crime spree in Digitown is not ending. This time 20 cars have been...
By Steve Jones
One of our mission statements in the Book of Redgate says: attempt to do...
Comments posted to this topic are about the item Helpful Management Studio Settings and...
Comments posted to this topic are about the item The Minimal Linked Server
Comments posted to this topic are about the item The AI View From Above
What is the minimal number of parameters to add a linked server with sp_addlinkedserver?
See possible answers