Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, ntile Rss

   Items 1 to 4 of 4   
 

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 | 3,123 reads

NTILE

By Kshitij Satpute 2013/08/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,146 reads

SQL Server Ranking Functions

A new article from Wayne Sheffield that examines the ranking functions in SQL Server. Learn how you can use ROW_NUMBER(), NTILE(), RANK(), and DENSE_RANK() in your applications.  Read more...
By Wayne Sheffield 2010/04/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 13,940 reads

Exploring SQL 2005’s Ranking Functions – NTILE() and ROW_NUMBER()

Part 20 of the "SqlCredit – Developing a Complete SQL Server OLTP Database Project" examines SQL 2005’s NTILE() and ROW_NUMBER() Ranking Functions.  Read more...
By Additional Articles 2008/11/06 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 4,021 reads
   Items 1 to 4 of 4   
 
Tags
ranking functions (3)    
dense_rank() (1)    
execution plan (1)    
lazy spool (1)    
percent_rank (1)    
percentile rank (1)    
rank distribution function (1)    
row_number() (1)    
window aggregate function (1)    
window distribution function (1)