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

Content with tag window functions Rss

   Items 1 to 20 of 22    Older >>
 

The Lonely Count

By Steve Jones 2016/01/07 | Category: window functions
Rating: (not yet rated) |  Discuss |   Briefcase | 1,494 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,084 reads

Understanding the OVER clause

Having a solid knowledge of the window functions if vital to high performance T-SQL Code. The key to these functions is how the OVER clause is used. This article will dive into how to use the OVER clause.  Read more...
By Wayne Sheffield 2015/10/14 | Source: SQLServerCentral.com | Category: over clause
Rating: |  Discuss |   Briefcase | 15,461 reads

LEAD parameters

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

Using LAG

By Kathi Kellenberger 2015/04/15 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,858 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 2015/04/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 17,076 reads

Running Total Performance

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

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 | 9,208 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,601 reads

All the rows before this one

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

Windowing Ranges

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

High-Performance Transact-SQL with Window Functions

Window functions are more intuitive and simpler in many cases than alternative SQL methods.  Read more...
By Kamil Moscicki 2013/12/02 | Source: SQLServerCentral.com | Category: sql performance
Rating: |  Discuss |   Briefcase | 8,284 reads

Window Functions in SQL

SQL's windowing functions are surprisingly versatile, and allow us to cut out all those self-joins and explicit cursors. Joe Celko explains how they are used, and shows a few tricks such as calculating deltas in a time series, and filling in gaps.   Read more...
By Additional Articles 2013/11/14 | Source: SimpleTalk | Category: window functions
Rating: (not yet rated)  Rate this |   Briefcase | 6,993 reads

Calculating Values within a Rolling Window in Transact SQL

Before the SQL Window functions were implemented, it was tricky to calculate rolling totals or moving averages efficiently in SQL Server. There are now a number of techniques, but which has the best performance? Dwain Camps gets out the metaphorical stopwatch.  Read more...
By Additional Articles 2013/11/01 | Source: SimpleTalk | Category: window functions
Rating: (not yet rated)  Rate this |   Briefcase | 4,164 reads

SQL Server 2012 Window Function Basics

For some time, Microsoft had a few window functions, but not the full set specified in the SQL 2003 standard. Now, in SQL Server 2012 we have the whole range, and extremely useful they are too. There's no longer an excuse to avoid them, particularly now you have Rob Sheldon's gentle introduction.  Read more...
By Additional Articles 2013/04/04 | Source: SimpleTalk | Category: sql server 2012
Rating:  Rate this |   Briefcase | 4,547 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 | 6,598 reads

Window Functions in SQL Server: Part 3: Questions of Performance

A SQL expression may look elegant on the page but it is only valuable if its performance is good. Do window functions run quicker than their conventional equivalent code? Fabiano Amorim gives a definitive answer.  Read more...
By Additional Articles 2012/01/17 | Source: SimpleTalk | Category: window functions
Rating:  Rate this |   Briefcase | 3,550 reads
   Items 1 to 20 of 22    Older >>
 
Tags
t-sql (13)    
over clause (4)    
lag (3)    
lead (3)    
sql server 2012 (3)    
performance (2)    
window aggregate (2)    
analytic functions (1)    
analytical functions (1)    
blogs (1)    
count() (1)    
cte (1)    
cursors (1)    
datediff (1)    
first_value (1)    
framing (1)    
last_value (1)    
performance tuning (1)    
rows and range (1)    
running totals (1)    
sql performance (1)