Stairway to T-SQL DML

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

  • Stairway Step

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.


17,322 reads

Technical Article

Hardware Selection

  • Topic

I need some advice on how to set up the most optimal drive configuration for a new MS SQL Server machine. Which version of RAID would you choose?  Is it best to have 3 separate controllers attached to 3 separate sets of drives with one each reservered for Data, Indexes, and Transaction logs?  Or is there […]


1 reads

Technical Article

Copying only the structure of a DB

  • Topic

I have a populated SQL 2000 database...and I'd like to make 2 empty copies of it....Basically, we want to populate 2 new db's with different data....but with the same structure as the original populated db.What would be the best way to do this? Thanks!


1 reads


Daily Coping 29 Nov 2022


Today’s coping tip is to make a meal using a recipe or ingredient you’ve...

My adventures with speaking and what changed


I am writing this blog post as contribution to #NewStarNovember and what got me...

Automatically Take Missed Backups with Ola Hallengren’s Scripts


I blogged a few years ago about my configuration tables for Ola Hallengren’s maintenance...

Read the latest Blogs


Basic Checks on a New AWS RDS SQL Server

By Br. Kenneth Igiri

Comments posted to this topic are about the item Basic Checks on a New...

Assigning a Server Role

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Assigning a Server Role

Cloud First Software

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cloud First Software

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers