SQL Group By Archives - SQL Authority with Pinal Dave

Dec 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – Count Occurrences of a Specific Value in a Column

June 12, 2023

SQL Interview Questions and Answers

SQL Group By, SQL Server

Here is the exact question – How to Count Occurrences of a Specific Value in a Column? Well, honestly, the answer is very simple.

SQL SERVER – Stream Aggregate and Hash Aggregate

February 17, 2020

SQL Performance

Execution Plan, MAXDOP, Parallel, Query Hint, SQL Group By, SQL Operator, SQL Server Management Studio, SSMS

Recently during the on-demand consultation, I was asked a very interesting question about Stream Aggregate and Hash Aggregate.

SQL SERVER – Group By Orders Data by Columns Ascending

October 23, 2019

SQL Tips and Tricks

SQL Group By, SQL Order By, SQL Scripts, SQL Server

The question was about Group By Orders Data by Columns Ascending. DBA asked me an interesting question referring to my older blog.