Learn what query plan caching and parameter sniffing are, how they affect your SQL queries, and how to debug and fix them using tools and techniques in SQL Server.

In SQL Server 2016, Microsoft also added the query store, which helps track query performance and execution plans over time. While the query store is a fantastic tool for monitoring query ...

Part of the SQL Server 2022 blog series.. Query Store is one of the most powerful database-scoped features in SQL Server for troubleshooting performance and improving the stability of your database ...

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