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)

You rated this post out of 5. Change rating

2009-05-29 (first published: )

10,051 reads

Blogs

Create and Verify Microsoft Fabric Capacity

By

From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....

What is Always Encrypted and how does it work?

By

Always Encrypted was a new encryption feature added to SQL Server with the 2016...

Power BI – Empowering Users to Disable Tooltips

By

Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your...

Read the latest Blogs

Forums

Display columns from multiple rows in single

By gjoelson 29755

Hello,  Im looking for assistance. I have this query and need to display the...

Azure Dataware or Azure SQL Pools and equivalent to profiler in Azure...

By digdave7

I added the Profiler module to AZure Data Studio in our ("Microsoft Azure SQL...

Reset launchpad service to use default account

By Pete Bishop

I have an issue with SQL Server Launchpad service. Initially it wouldn't start (configured...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Refresh Limits

See possible answers