Joey on SQL Server. Deep Dive into SQL Server 2022's Query Performance Features, Part 2: PSP Optimization. Reduce workload times with this handy feature that can benefit every database pro.

However, SQL Server 2016 also fully supports the rowset-to-JSON query scenario when you write a regular T-SQL query and then map results to JSON objects via the FOR JSON clause. For more information ...