Investigate CXSYNC_PORT with session wait deltas, parallel plan exchanges and thread rows before testing a query-level MAXDOP change.
JSON_OBJECT and JSON_ARRAY: Building JSON in SQL Server 2022
Build JSON_OBJECT and JSON_ARRAY values in SQL Server 2022, control null handling, nest arrays, and compare rowset and aggregate output.
DOP Feedback: Letting SQL Server Lower Parallelism by Itself
Configure DOP feedback in SQL Server 2022, check Query Store evidence, and compare parallelism changes with your workload and MAXDOP limits.
Granular Server Roles: ##MS_ServerStateReader## and Friends
Assign granular server roles in SQL Server 2022, inspect membership, and give monitoring accounts the state access their queries need.
IS DISTINCT FROM in SQL Server 2022: NULL-Safe Comparisons
Use IS DISTINCT FROM for NULL-safe comparisons in SQL Server 2022, understand older workarounds, and inspect index seeks before changing code.
Bit Functions in SQL Server 2022: BIT_COUNT, GET_BIT and LEFT_SHIFT
Use BIT_COUNT and SQL Server 2022 bit functions to read, set, count, and shift flags, while choosing clear storage for ordinary settings.
GREATEST, LEAST and Other Small Helpers
GREATEST, LEAST, and recent T-SQL helpers replace bulky CASE patterns while preserving explicit rules for NULL and data types.