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

Content with tags Performance, window functions Rss

   Items 1 to 2 of 2   
 

Reaping the benefits of the Window functions in T-SQL

Exploring the potential benefits of the T-SQL Window functions (OVER, LAG, and LEAD) in this piece. You can learn how to achieve up to 50% performance boost by replacing a single function call.   Read more...
By Eirikur Eiriksson 2014/03/24 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 8,555 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,089 reads
   Items 1 to 2 of 2   
 
Tags
lag (1)    
lead (1)    
over clause (1)    
sql server 2012 (1)    
t-sql (1)