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 data partitioning and organization strategies to drastically improve query performance in analytical databases.
Explains why transactional data models are inefficient for analytics and how to design denormalized, query-optimized models for better performance.
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.
Explains how ToDictionaryAsync in Entity Framework Core retrieves entire database objects, impacting performance, and provides a solution using Select.
Demonstrates a 6x speedup for analytics queries using EDB Postgres Distributed's new analytics engine compared to the standard Postgres engine.
Explains a new PostgreSQL 19 feature that displays Memoize planner estimates in EXPLAIN output to help debug query plan choices.
