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. By Joey ...

If you are on SQL Server 2016 or higher and you aren't using the query store feature, you are missing out on the single best database performance diagnostic tool I've used in 21 years of working ...

The three features of adaptive query processing can make SQL Server 2017 significantly faster at processing your workload. Not only that, but they also provide significant improvements without needing ...

As I discussed in an earlier column, SQL Server keeps a plan cached for each query it sees (assuming the query requires planning in the first place, of course). That's great for speeding up processing ...

Probably for a query that your application runs occasionally, in-memory processing of JSON data might still be an option. In general, though, querying through JSON-dedicated functions and letting SQL ...