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,240 reads

Blogs

What the ???? T-SQL Tuesday #120

By

Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...

First Time Speaking at PASS Summit

By

This week, I filmed my experience as a first time speaker at PASS Summit...

Azure SQL Best Practices?

By

A way to enforce good practice and standards is by Azure Policy. As stated...

Read the latest Blogs

Forums

https://dragonsdenketo.com/peau-jeune-creme/

By aronscoates

Peau Jeune Creme The ingredients labels on anti aging skin care products are your...

What is the reason behind Driver unavailable error in window?

By Jeromeassistant

Casting insight on different aspect of the assembling and configuration part of printer.  The...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers