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

Articles with tag max Rss

Search for any content tagged max

   Items 1 to 3 of 3   
 

Windowing Functions: Tell me when that changes

Windowing functions aren't just for analyzing numbers/dates. Using windows functions to analyze when a character field changes is a little know resource  Read more...
By Michael Morin 2017/03/17 (first published: 2016/02/17) | Source: SQLServerCentral.com | Category: windows functions
Rating: |  Discuss |   Briefcase | 7,035 reads

Windowing Functions: Tell me when that changes

Windowing functions aren't just for analyzing numbers/dates. Using windows functions to analyze when a character field changes is a little know resource  Read more...
By Michael Morin 2017/03/17 (first published: 2016/02/17) | Source: SQLServerCentral.com | Category: windows functions
Rating: |  Discuss |   Briefcase | 7,035 reads

Maintaining a grouped running MAX (or MIN)

If you're on SQL Server 2012 or greater, you definitely want to become familiar with all of the extensions to the windowing functions first introduced in SQL Server 2005 – they may give you some pretty serious performance boosts when revisiting code that is still running "the old way." Aaron Bertrand explains.  Read more...
By Additional Articles 2015/10/21 | Category: max
Rating: (not yet rated)  Rate this |   Briefcase | 3,923 reads
   Items 1 to 3 of 3