TF3604 Blog

Search
Skip to content
  • About
  • Tools
    • SQL Server Log File Visualizer
    • SQL Server Query Tree Viewer
  • Presentations
    • Create a Simple Operational Data Store
    • dbatools: The PowerShell way to interact with SQL Server
    • Intro to SQL Server Machine Learning Services
    • Let’s Explore SQL Storage Internals
    • Real-World PowerShell for SQL Administration
    • Remember Back When? Temporal Tables in SQL Server 2016 & 2017
    • Set Me Up: How to Think in Sets
      • Results from How to Think in Sets – SQL Saturday Baton Rouge 2017
      • Results from How to Think in Sets – SQL Saturday Kansas City 2017
      • Results from How to Think in Sets – SQL Saturday Sioux Falls 2017
      • Results from How to Think in Sets – SQL Saturday Wausau 2017
    • The Amazing Utility of ROW_NUMBER()
    • Window Functions in SQL
    • Parse Trees, Memos, Transformation Rules and Other Hidden Objects in SQL Server
    • Visualize Your Transaction Log

The Amazing Utility of ROW_NUMBER()

This presentation discusses some of the great (and perhaps unexpected) things that you can do with the humble ROW_NUMBER() function.

  • Slide deck (PDF)
  • Scripts

Presentation History:

  • SQL Saturday 721 (Raleigh, North Carolina), 14 April 2018
  • SQL Saturday 752 (Iowa City, Iowa), 23 June 2018
  • SQL Saturday 825 (Chicago, Illinois), 23 March 2019
  • SQL Saturday 1026 (Baton Rouge, Louisiana), 6 August 2022
  • Data Saturday 26 (Dallas, Texas), 24 September 2022

Probing the internals of SQL Server

June 2025
S M T W T F S
1234567
891011121314
15161718192021
22232425262728
2930  
« Oct    

Archives

  • October 2019
  • November 2018
  • January 2018
  • October 2017
  • October 2016
  • September 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • May 2015
  • April 2014
  • January 2014
  • November 2013

Recent Posts

  • Stored Procedure to determine when a job is done
  • Testing Scalar UDF Performance on SQL Server 2019
  • SELECTing from a VALUES clause
  • One Year Gone
  • Halloween Protection

Recent Comments

  • David Roberts on United States geographic data: States and counties
  • Edgar on Stored Procedure to determine when a job is done
  • Brian Hansen on Stored Procedure to determine when a job is done
  • Mario Carino on Stored Procedure to determine when a job is done
  • Jon Lunn on Emulating Excel’s NORMDIST in T-SQL

Categories

  • Administration
  • Community
  • Diagnostics
  • Geospatial
  • Hekaton
  • How-to
  • Internals
  • Performance
  • SQL Development
  • SQL Server 2014
  • SQL Server 2016
  • Statistics
  • T-SQL
  • Uncategorized
  • User-Defined Functions

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Proudly powered by WordPress