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.

I have a test server hosting several sites using SQL Server Express and SQL Management Studio Express. I've seen one site have an occasional issue where queries to a particular table (the ...

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.