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.

I'm doing some development on a dev server of ours for a site that's currently live on another server. They have their own server with a SQL Server database holding the data for the live site. So ...

Have entry in .env file: "QUERY_BATCH_SIZE = 2098" to overcome SQL Server error: "The incoming request has too many parameters. The server supports a maximum of 2100 parameters.