aggregate functions — 2 Technical Articles

Mar 18, 2017 · Databases

Mastering SQL Server Aggregate Functions: Optimization Tips and Techniques

This article explains SQL Server aggregate functions, detailing scalar and hash aggregation concepts, demonstrates execution‑plan analysis with COUNT examples, and provides practical optimization techniques such as avoiding sorting and adding non‑clustered indexes, while also covering monitoring metrics for performance tuning.

IndexesPerformance optimizationSQL Server

0 likes · 9 min read

Mastering SQL Server Aggregate Functions: Optimization Tips and Techniques

ITPUB

Apr 3, 2016 · Databases

Master SQL GROUP BY: From Simple Aggregations to Rollup and Joins

This guide explains how to use SQL's GROUP BY clause with examples covering basic grouping, GROUP_CONCAT, aggregate functions, HAVING filters, multi‑column grouping, WITH ROLLUP, and inner, left, and right joins, illustrating each technique with clear query results.

GROUP BYHAVINGSQL

0 likes · 7 min read

Master SQL GROUP BY: From Simple Aggregations to Rollup and Joins