Build Parquet exports from SQL Server 2022 with PolyBase CETAS, S3-compatible storage, and checks for rows, types, and files.
IGNORE NULLS in SQL Server 2022: Carrying the Last Known Value Forward
Use IGNORE NULLS for forward-filled readings, find the next known value, and compare the older running-count grouping method carefully.
LTRIM and RTRIM With Custom Characters in SQL Server 2022
Use LTRIM and RTRIM with custom characters in SQL Server 2022, understand character sets, test TRIM directions, and preserve valid text.
Skipping No-Op Updates: Changing Only Rows That Really Differ
Skip no-op updates with NULL-safe EXCEPT or IS DISTINCT FROM, inspect affected counts, and avoid unnecessary rowversion and trigger changes.
Finding Free Time Slots in a Calendar With GENERATE_SERIES
Find free time slots with GENERATE_SERIES, exclude overlapping bookings, and merge busy intervals before calculating calendar gaps.
Tally Table: Replacing WHILE Loops With a Set of Numbers
Use a tally table or GENERATE_SERIES to replace repeated date, character, and missing-number loops with ordered sets of rows.
Parameter Sensitive Plans: Reading Query Variants in Query Store
Inspect query variants and dispatcher plans in Query Store, compare skewed parameter values, and read the boundaries selecting each plan.