Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tags T-SQL, window functions Rss

   Items 1 to 8 of 8   


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 2015/04/14 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 14,459 reads

Running Total Performance

By Kathi Kellenberger 2015/04/03 | Category: running totals
Rating: (not yet rated) |  Discuss |   Briefcase | 1,671 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,255 reads

All the rows before this one

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

Windowing Ranges

By Steve Jones 2013/12/09 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,292 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: | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 5,672 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 | 3,844 reads
   Items 1 to 8 of 8   
over clause (2)    
window aggregate (2)    
blogs (1)    
first_value (1)    
framing (1)    
last_value (1)    
performance (1)    
rows and range (1)    
running totals (1)    
sql server 2012 (1)