Francis Rodrigues


SQLServerCentral Article

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: )

9,480 reads

Blogs

VMware & SQL Server 823-824 alerts

By

We’ve been tracking a weird state with SQL Server virtual machines on VMware and...

Daily Coping 18 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Storage Field Day 23 – SIOS

By

I am thrilled to have been a part of this year’s Storage Field Day...

Read the latest Blogs

Forums

Quick Question on 2019 to older version?

By oogibah

A client of ours is upgrading their database to SQL Server 2019. The edition...

Mapping network drive to SSMS

By pols

Hi, I need to perform backup and save it in network drive. I have...

Extended Events to capture the queries run against the changed tracking tables.

By SQL_Hunt

Hello Group, Do you have any available extended events to capture the queries run...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers