Uncategorized

External Article

Using TOP clause in a SELECT statement

  • Article

There might be a time when you might want to return just a few rows of a result set, instead of the complete set. This might be useful if you want to just validate a selection criteria or a few rows of data. For whatever the reason the TOP clause can be used to return a specific number or a percentage of rows from a result set. This article will cover using the TOP clause in a SELECT statement and how it can be used to return a partial set of records.

2023-03-29

SQLServerCentral Editorial

Review Early and Often

  • Editorial

Several years ago, I was brought in on a project to review a database design. I was provided a time for a meeting. No written requirements were available, but I generally knew what the system was supposed to do. No before/after schema images showed what was being changed were available. Still, I was assured that […]

(4)

You rated this post out of 5. Change rating

2023-03-25

116 reads

SQLServerCentral Editorial

Sources of Inspiration

  • Editorial

I honestly enjoy writing editorials. Something pops into my tiny brain next to something else, and I'm off. However, today, as I started to write on the topic of learning, I suddenly felt like I had just written this same editorial. I go and look, sure enough, several of my recent editorials have been on […]

(1)

You rated this post out of 5. Change rating

2023-03-12 (first published: )

87 reads

SQLServerCentral Editorial

Constant Learning

  • Editorial

Yesterday, I had the opportunity, and the privilege, to attend an all-day workshop put on by Bob Ward teaching all about SQL Server 2022 (you can take this too, Bob is presenting it at SQLSaturday Austin and SQL Bits, and there will be more). It was a great day. Bob is an excellent teacher. Even […]

(2)

You rated this post out of 5. Change rating

2023-02-11

119 reads

Blogs

How AgentDBA Identifies Backup Failures

By

Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...

Tip: Expanding a SQL statement

By

In all recent versions of the database you can call DBMS_UTILITY.EXPAND_SQL_TEXT to get the...

AI Helps Me with My Sloppiness

By

I type fairly well. Well, I type fast, but I do wear out a...

Read the latest Blogs

Forums

From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline

By Cláudio Tereso

Comments posted to this topic are about the item From SQL Server On-Premises to...

Independence Day 2026

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Independence Day 2026

Independence Day 2026

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Independence Day 2026

Visit the forum

Question of the Day

Independence Day 2026

In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.

See possible answers