SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, PERCENT_RANK Rss

   Items 1 to 2 of 2   
 

Nasty Fast PERCENT_RANK

Alan Burstein discusses a better performning alternative to PERCENT_RANK that works on SQL Server versions 2005+  Read more...
By Alan Burstein 2016/06/07 | Source: SQLServerCentral.com | Category: percent_rank
Rating: |  Discuss |   Briefcase | 4,525 reads

Using the T-SQL PERCENTILE Analytic Functions in SQL Server 2000, 2005 and 2008

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.   Read more...
By Additional Articles 2015/05/27 | Source: SimpleTalk | Category: percent_rank
Rating: (not yet rated)  Rate this |   Briefcase | 7,539 reads
   Items 1 to 2 of 2   
 
Tags
execution plans (1)    
lazy spool (1)    
ntile (1)    
percentile rank (1)    
percentile_cont (1)    
percentile_disc (1)    
rank distribution function (1)    
window functions (1)