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.

In earlier versions of SQL Server, after selecting a join algorithm, SQL Server had to process it even if a better alternative might be available. In SQL Server 2017, the query optimizer can now sense ...

Joey on SQL Server How To Use Query Store Hints in Azure SQL Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the ...

SOS_SCHEDULER_YIELD —SQL Server instances with high CPU usage often show the SOS_SCHEDULER_YIELD wait type. This doesn’t mean the server is underpowered; it means further research is needed to find ...