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)
10,613 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
9,210 reads
The Query Answers with SQL Server Series
A series of articles based on the Query Answers with SQL Server book.
2018-06-29
3,919 reads
Blogs
SQL Saturday Denver 2023–VCS Primer for the Database slides
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
Future Data Driven 2023 is This Week
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Opening the SQL Prompt Command Palette
By Steve Jones
A few years ago SQL Prompt added a command palette to let you search...
Forums
Delegated rights to Enable/Disable TSQL Jobs (Specific Jobs)
All, In attempts thinking that I am smarter than your average bear, I attempted...
Hello i am new to Sql and idk why i get this error and also not getting results.
CREATE DATABASE dbsubjects; CREATE TABLE tblstudent( ID INTEGER PRIMARY KEY, TheName Varchar (100), TheAddress...
Identifying the process that is backing the databases to virtual device
We have about 20 SQL Servers. We use Net backup or Native backup for...
Ask SSC