Build real-time operational analytics with a filtered columnstore index, inspect batch-mode plans and rowgroups, and measure write costs.
Measuring Space Used by Tables per Filegroup in T-SQL
Measure tables per filegroup from allocation metadata, include LOB and overflow pages, and separate partition placement from growth history.
Finding the Most Frequent Value per Group in T-SQL
Find the most frequent value in each group, choose a tie policy, and compare categorical modes with averages and numeric percentiles.
A WHERE Filter That Turns Your LEFT JOIN Into an INNER JOIN
Fix a LEFT JOIN whose right-table WHERE filter removes unmatched rows, inspect the inner-join plan, and search modules for candidates.
The PRODUCT Aggregate: Multiplying Values Across Rows
Use the PRODUCT aggregate in SQL Server 2025 for growth factors and independent probabilities, with checks for NULL, zero, and precision.
Reading a JSON Lines File Into a Table With OPENROWSET
Load JSON Lines with OPENROWSET BULK, keep UTF-8 text intact, quarantine invalid objects, and insert validated typed rows.
UNION vs UNION ALL: Reading the Operators Each One Adds to a Plan
Compare UNION vs UNION ALL through actual plans, duplicate-removal operators, memory grants and reads, then prove when branches cannot overlap.