Build a dynamic PIVOT with ordered STRING_AGG and QUOTENAME, parameterized filters, zero-filled results, and explicit report-width limits.
What Changes When You Move to a New Major Version
A New Major Version of SQL Server changes the engine while database compatibility, query plans, and deprecated features need separate review.
CASE Sort Priority: Put Business Order Before Alphabetical Order
CASE sort priority makes the queue policy explicit. Map known statuses to numeric ranks and keep missing or unfamiliar labels visible. Finish tied ranks with a unique key.
Ordered Columnstore Indexes in SQL Server 2022
Build an ordered columnstore index in SQL Server 2022, inspect segment bounds, and compare range-query reads on your own data.
Adaptive Joins: When the Plan Picks Its Join at Run Time
Understand adaptive joins in SQL Server, read their runtime threshold, inspect the actual choice, and test a query hint safely.
PI: Choose the Precision of a Circle Calculation
PI provides an approximate circle constant. This example keeps radius, circumference and two area calculations together to show when a chosen decimal conversion occurs.
geometry STIntersection: Return the Shared Shape
geometry STIntersection returns the shared shape rather than only an intersection flag. I inspect its type and emptiness alongside its area. A shared edge has zero area but still contains points.