Francis Rodrigues

ROW_NUMBER(): An efficient alternative to subqueries – Scenario 2

Introduction In the first article I discussed how the ROW_NUMBER() function can cut down resources spent on queries dealing with versioning. In this article I will discuss how the ROW_NUMBER() function can help when dealing with range requirements. The code samples are available for download. The name of the file is RowCountScenario2-CodeDownload.sql. Scenario 2 – […]

4.24 (21)

2009-05-29 (first published: )

8,110 reads

Blogs

Migrating SSIS to Azure – Slidedeck (Techorama 2019)

By

Techorama 2019 is over and it was a blast, as usual. Neatly organised, great...

Containers: Create a Custom Container

By

Creating a custom container is where things get truly exciting. There’s actually a ton...

Mini-Rant: Spoofed Phone Numbers and Trust

By

I’ve seen this more and more over the last year: I receive a phone...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

Function Issues

By MattNorman88

I have created the following function which is to be used for a check...

SQL Server health check

By 892717952

If I want to do a SQL Server health check, which aspects should be...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers