A developer explains how Claude Code convinced them to simplify SQL JOINs by moving filters from ON to WHERE clauses for better readability.
Explores nine key design tradeoffs in query engines like PostgreSQL, ClickHouse, and DuckDB, covering storage, indexing, execution, and concurrency.
Explains how Apache Iceberg uses metadata for data skipping, enabling fast query performance by eliminating 90-99% of files before scanning.
Brent Ozar details tactics for teaching his Dev-Prod Demon Hunters SQL performance session, including demos, checklists, and a new tool.
Explores why SQL Server performance tuning often fails, focusing on systemic issues beyond indexes and queries.
Optimizing HTTP queries with Marten and Wolverine for faster JSON streaming from PostgreSQL.
Guide to diagnosing and fixing SQL Server performance issues, covering common causes like poor queries, missing indexes, and blocking.
Identifies five common causes for sudden SQL Server slowdowns and explains how to diagnose them effectively.
PasteThePlan.com now offers free AI-powered SQL query optimization advice using ChatGPT 5.3 to analyze execution plans.
New PostgreSQL 18 and SQLite features allow developers to copy database statistics to test production query plans without moving large datasets.
New PostgreSQL 18 and SQLite features allow developers to copy database statistics to replicate production query plans in dev environments.
Explains why transactional data models are inefficient for analytics and how to design denormalized, query-optimized models for better performance.
Explains data partitioning and organization strategies to drastically improve query performance in analytical databases.
Compares how Oracle and PostgreSQL uniquely identify SQL queries and execution plans, focusing on SQL_ID vs query_id and PLAN_HASH_VALUE vs query_hash.
Explains a SQL Server edge case where automatic statistics updates don't always invalidate cached execution plans, focusing on system-created stats.
Explores the new ABORT_QUERY_EXECUTION query hint in SQL Server 2025 for blocking problematic queries via Query Store.
Explains the Optional Parameter Plan Optimization (OPPO) feature in SQL Server 2025, part of Intelligent Query Processing to mitigate parameter sniffing issues.
Explores the limitations of traditional pull queries in data systems and advocates for using materialized views and data duplication to improve performance.
Explores the shift from traditional pull queries to using materialized views and data duplication for better performance, format, and location in data systems.
PostgreSQL 19 introduces GROUP BY ALL, a new SQL feature that automatically groups by all non-aggregate columns, simplifying queries.
