Creating Subtotals and Totals in Aggregated Queries
Grouping Sets are an effective way to add subtotals to aggregated queries. T His article explains how.
2020-09-25 (first published: 2018-09-06)
11,304 reads
Query Answers with SQL Server
Segment Data into Deciles
This short article shows a simple example of how to segment data into deciles
2018-07-19
10,682 reads
The Query Answers with SQL Server Series
A series of articles based on the Query Answers with SQL Server book.
2018-06-29
4,166 reads
Blogs
Build a Dockerized Todo List RESTful API in C# with GitHub Actions and Azure Container App: A…
Build a Dockerized Todo List RESTful API in C# with GitHub Actions and Azure...
Cyber Scams and Operation Shamrock
By Brian Kelley
Erin West gave the keynote for the 2025 Techno Security & Digital Forensics East...
The Book of Redgate: Ingeniously Simple
By Steve Jones
Redgate has been known for many useful tools that are easy to use. We’ve...
Forums
Shorten the Debate
Comments posted to this topic are about the item Shorten the Debate
Azure SQL Performance Tuning: Mastering Indexes, Partitioning, and Clustered Columnstore
Comments posted to this topic are about the item Azure SQL Performance Tuning: Mastering...
Adding Lots of Dates
Comments posted to this topic are about the item Adding Lots of Dates
Question of the Day
Adding Lots of Dates
The second parameter for the EOMONTH() function is an integer. In June 2025, if I run this code, what is returned?
DECLARE @d DATE = GETDATE() SELECT EOMONTH(@d, 95695)See possible answers