Execution Plans Articles

Page 1 of 1 (4 articles)

8/6/2026 • EN

SQL Server Query Store: Why Performance History Matters

Explains how SQL Server Query Store helps investigate performance issues after they occur by analyzing historical query plans and runtime behavior.

Database Optimization Execution Plans performance tuning Query Store SQL Server

Bjoern Peters

3/21/2026 • EN

SQL Server Slow? How to Analyze and Fix Performance Issues

Guide to diagnosing and fixing SQL Server performance issues, covering common causes like poor queries, missing indexes, and blocking.

Database Troubleshooting Execution Plans indexing Query Optimization SQL Server Performance

Bjoern Peters

1/5/2019 • EN

Optimize for Analytics (Should be a Database Configuration option)

A proposal for a new "Optimize for Analytics" database configuration option in SQL Server and Azure SQL Database to enhance performance for data warehousing workloads.

Azure SQL Database Database Optimization Execution Plans Query Performance SQL Server

Niko Neugebauer

6/13/2013 • EN

Explaining your PostgreSQL data

A guide to using EXPLAIN and EXPLAIN ANALYZE in PostgreSQL, including JSON output and visualization tools for query execution plans.

Database Performance Execution Plans Explain postgresql Query Optimization

Craig Kerstiens

Execution Plans Articles

SQL Server Query Store: Why Performance History Matters

SQL Server Slow? How to Analyze and Fix Performance Issues

Optimize for Analytics (Should be a Database Configuration option)

Explaining your PostgreSQL data

Select Language

We use cookies