Gregory Larsen

Currently a SQL Server DBA. I've been working with SQL Server since 1999. I'm an old-time mainframe DBA. My DBA career started in 1985. Currently studying to obtaining MCDBA.

All authors

Stairway to T-SQL DML Level 11: How to Delete Rows from a Table

by Gregory Larsen

SQLServerCentral

You may have data in a database that was inserted into a table by mistake, or you may have data in your tables that is no longer of value. In either case, when you have unwanted data in a table you need a way to remove it. The DELETE statement can be used to eliminate data in a table that is no longer needed. In this article you will see the different ways to use the DELETE statement to identify and remove unwanted data from your SQL Server tables.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2012-09-19

12,757 reads

Discuss

Stairway to T-SQL DML Level 9: Adding Records to a table using INSERT Statement

by Gregory Larsen

SQLServerCentral.com

Not all applications are limited to only retrieving data from a database. Your application might need to insert, update or delete data as well. In this article, I will be discussing various ways to insert data into a table using an INSERT statement.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2012-09-05

10,880 reads

Discuss

Stairway to T-SQL DML Level 8: Using the ROLLUP, CUBE and GROUPING SET operator in a GROUP BY Clause

by Gregory Larsen

SQLServerCentral

In this article I will be expanding on my discussion of the GROUP BY clause by exploring the ROLLUP, CUBE and GROUPING SETS operators. These additional GROUP BY operators make it is easy to have SQL Server create subtotals, grand totals, a superset of subtotals, as well as multiple aggregate groupings in a single SELECT statement.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2012-08-22

18,134 reads

Discuss

Stairway to T-SQL DML Level 7: Summarizing Data Using a Simple GROUP BY Clause

by Gregory Larsen

SQLServerCentral

In this article you will be see how to group data using the simple GROUP BY clause, in order to summarize more complex data.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2012-01-04

13,500 reads

Discuss

Stairway to T-SQL DML Level 6: The Basics of Sorting Data Using the ORDER BY Clause

by Gregory Larsen

SQLServerCentral

In this Level you will see how to use the ORDER BY clause to return your data in a sorted order.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2011-12-14

13,476 reads

Discuss

Stairway to T-SQL DML Level 2: History of Structured Query Language (SQL)

by Gregory Larsen

SQLServerCentral.com

Let’s step back in time and discuss the history of Structured Query Language, or what most SQL Server professionals just shorten to SQL. Fasten your seatbelts, crank up the time machine and travel back in time to follow the history of SQL and Microsoft SQL Server from its early years to where they are today.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2011-10-21

14,444 reads

Discuss

Stairway to T-SQL DML Level 1: The Basic SELECT Statement

by Gregory Larsen

SQLServerCentral.com

There are lots of different aspects of managing data in a SQL Server database. Before you can get into the complex management issues associated with managing application data you need to start with the basic of retrieving data from a table. To return data from a SQL Server table you use a SELECT statement. In this level I will be cover the components of the basic SELECT statement and how you can use it to retrieve data from a single SQL Server table.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2011-10-07

29,737 reads

Discuss

Submitting A Stored Procedure Asynchronously

by Gregory Larsen

Database Journal

Advanced Querying

Have you ever wondered if you could start the execution of a stored procedure (SP) asynchronously from some T-SQL code? What I mean is starting the SP in the background and continuing on with the next line of code in your T-SQL script without waiting for the execution of the SP to complete. If so, then this article might be of some interest to you.

2004-12-01

3,279 reads

Discuss

SQL MAIL Using POP3 and SMTP

by Gregory Larsen

SQLServerCentral.com

SQLMail

SQL Server has a great build in messaging system with SQLMail. Unfortunately it requires Outlook and Exchange to work properly. Some people don't like this or do not run Exchange and have issues getting it to work. Gregory Larsen takes a look at how you can use SMTP to send email from SQL Server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-11-23

21,110 reads

Discuss

Sequential Numbering

by Gregory Larsen

SQLServerCentral.com

Advanced Querying

Needing to number rows with a sequential id is a pretty common request. Sometimes it's because the user hasn't made the transition to 'set based' thinking, sometimes it really is a valid request (more or less!). Greg provides several different techniques to help you achieve sequential numbering.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2003-12-05

11,073 reads

Discuss

All authors

Gregory Larsen

Stairway to T-SQL DML Level 11: How to Delete Rows from a Table

Stairway to T-SQL DML Level 9: Adding Records to a table using INSERT Statement

Stairway to T-SQL DML Level 8: Using the ROLLUP, CUBE and GROUPING SET operator in a GROUP BY Clause

Stairway to T-SQL DML Level 7: Summarizing Data Using a Simple GROUP BY Clause

Stairway to T-SQL DML Level 6: The Basics of Sorting Data Using the ORDER BY Clause

Stairway to T-SQL DML Level 2: History of Structured Query Language (SQL)

Stairway to T-SQL DML Level 1: The Basic SELECT Statement

Submitting A Stored Procedure Asynchronously

SQL MAIL Using POP3 and SMTP

Sequential Numbering

Blogs

SQL Server 2025 RegEx and AI

T-SQL Tuesday #192: SQL Server 2025 Backup Changes

Why Databases Still Fascinate Me

Forums

How do you approach engineering services consulting?

Columnstore index question

Transactional Replication

Question of the Day

Identify a Slipstream Installation