THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » OVER clause » row_number   (RSS)
  • Please Vote: Windowing Enhancements in SQL Server

    Back in January 2007, SQL guru Itzik Ben-Gan posted a series of MS Connect enhancement requests concerning windowing function enhancements.  Those who have used the ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE() functions on SQL 2005 and 2008, you already know how useful they are.  They simplify code and can improve performance ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on November 19, 2009
  • Demos From Cape Cod .NET: T-SQL Power! Presentation

    On Tuesday night I was honored to present a new talk to the Cape Cod .NET Users Group that meets in Plymouth, MA. The talk is called ''T-SQL Power! Learning to Harness the Under-Used OVER Clause''. Following is the abstract for the talk:First introduced in SQL Server 2005, the OVER clause is an ANSI SQL enhancement that gives you tremendous ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 18, 2009
Privacy Statement