This week’s query exercise asked you to find two kinds of locations in the Stack Overflow database.

There's No Free Lunch with Open-source Software

by RyanBooz

SQLServerCentral

As a member of the PostgreSQL open-source community, I have been following the recent license change by Redis Labes on March 20, 2024. Redis introduced a dual license model, specifically adding the Redis Source Available License (RSAL), which prevents other vendors from providing Redis as a service without a paid subscription from Redis Labs. The […]

Breaking Down DENSE_RANK(): A Step-by-Step Guide for SQL Enthusiasts

by Johnny_35

SQLServerCentral

Uncategorized

Learn how it works and how to use the DENSE_RANK() function in your code.

When Are Your Breaks?

by Steve Jones

SQLServerCentral

holiday

Today Steve asks for your holiday plans and ideas.

Department of Redundancy Department

by Additional Articles

SimpleTalk

Ever wonder all the reasons that we use databases instead of file systems? While we don’t think of it too much anymore, the first reason that databases came into existence was to remove redundancies.

Stairway to Advanced T-SQL Level 4: Record Level Processing Using Transact-SQL Cursors

by Gregory Larsen

SQLServerCentral.com

Using a CURSOR is not normally the best way to process through a set of records. Yet when a seasoned programmer moves to writing TSQL for the first time they frequently look for ways to process a sets of records one row at a time. They do this because they are not used to thinking about processing records as a set. In order to process through a TSQL record set a row at a time you can use a cursor. A cursor is a record set that is defined with the DECLARE CURSOR statement. Cursors can be defined as either read-only or updatable. In this article I will introduce you to using cursors to do record level processing one row at a time.