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.

An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine since its inception.

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 SQL Server 2022, Query Store is enabled by default to help database administrators (DBAs) gain insights on query plan choice and performance impact.

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

html-query-plan is a JavaScript library for showing Microsoft SQL Server execution plans in HTML. To use in a web page: Find the latest release here. Include qp.css and qp.min.js Call QP.showPlan, ...

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.