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

Content with tags T-SQL, window functions Rss

   Items 1 to 19 of 19   
 

Solving FIFO Queues Using Windowed Functions

One common request often seen in T-SQL is working with queues of information. In this piece, J. Drew Allen will show to use windowing functions and the OVER clause to process a FIFO queue.  Read more...
By J. Drew Allen 2016/10/06 | Source: SQLServerCentral.com | Category: fifo queues
Rating: |  Discuss |   Briefcase | 2,525 reads

Relative Rank

By Nagaraju Kambaluri 2016/08/12 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,175 reads

The Last Order

By Steve Jones 2016/06/07 | Category: last_value
Rating: (not yet rated) |  Discuss |   Briefcase | 1,355 reads

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,255 reads

Using LAST_VALUE

When I began using LAST_VALUE, the results were not what I expected at all. Read on to learn the secret!  Read more...
By Kathi Kellenberger 2016/06/03 (first published: 2015/04/14) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 22,817 reads

The Lonely Count

By Steve Jones 2016/01/07 | Category: window functions
Rating: (not yet rated) |  Discuss |   Briefcase | 1,639 reads

Cursor-Killing: Accessing Data in the Next Row

Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? This first part in an ongoing series of cursor-killing handles inter-row analysis.  Read more...
By Edward Pollack 2015/12/18 (first published: 2014/05/27) | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 21,939 reads

LEAD parameters

By Steve Jones 2015/05/15 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,710 reads

Using LAG

By Kathi Kellenberger 2015/04/15 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,900 reads

Using LAST_VALUE

When I began using LAST_VALUE, the results were not what I expected at all. Read on to learn the secret!  Read more...
By Kathi Kellenberger 2016/06/03 (first published: 2015/04/14) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 22,817 reads

Running Total Performance

By Kathi Kellenberger 2015/04/03 | Category: running totals
Rating: (not yet rated) |  Discuss |   Briefcase | 1,862 reads

Cursor-Killing: Accessing Data in the Next Row

Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? This first part in an ongoing series of cursor-killing handles inter-row analysis.  Read more...
By Edward Pollack 2015/12/18 (first published: 2014/05/27) | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 21,939 reads

The Performance of the T-SQL Window Functions

Window Functions in SQL greatly simplify a whole range of financial and statistical aggregations on sets of data. Because there is less SQL on the page, it is easy to assume that the performance is better too: but is it? Dwain gets out the test harness to investigate.  Read more...
By Additional Articles 2014/02/06 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 4,954 reads

All the rows before this one

By Steve Jones 2013/12/20 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,252 reads

Windowing Ranges

By Steve Jones 2013/12/09 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,348 reads

SQL Server : Usage of OVER Clause

Over  clause can be used in association with aggregate function and ranking function. The over clause determine the partitioning and...  Read more...
By nelsonaloor 2012/09/17 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 7,576 reads

Window Functions in SQL Server

With SQL Server 2012, we are soon to enjoy a full range of Window Functions. They are going to make for some much simpler SQL queries, as Fabiano Amorim ably demonstrates here.  Read more...
By Additional Articles 2011/11/14 | Source: SimpleTalk | Category: sql server 2012
Rating: (not yet rated)  Rate this |   Briefcase | 4,164 reads
   Items 1 to 19 of 19   
 
Tags
over clause (3)    
lag (2)    
last_value (2)    
lead (2)    
analytic functions (1)    
analytical functions (1)    
blogs (1)    
count() (1)    
cte (1)    
cursors (1)    
datediff (1)    
execution plans (1)    
fifo queues (1)    
first_value (1)    
framing (1)    
lazy spool (1)    
ntile (1)    
percent_rank (1)    
percentile rank (1)    
performance (1)    
rank distribution function (1)    
rows and range (1)    
running totals (1)    
sql server 2012 (1)