A guide to common SQL mistakes and optimization opportunities for developers and data professionals, covering integer division, UNION vs UNION ALL, and query performance.
Performance analysis of SQL Server 2019's Batch Execution Mode on TPC-H queries using rowstore indexes and compressed data.
Explores a new feature in SQL Server 2019's SET STATISTICS IO output, revealing detailed I/O metrics for INSERT operations into target tables.
Explores the heuristics and conditions under which SQL Server's Query Optimizer decides to use Batch Mode execution for query processing.
Explores SQL Server 2019's new Batch Execution Mode for Rowstore indexes, covering basics, enabling it, and analyzing performance.
Explains a performance pitfall with Common Table Expressions (CTEs) in PostgreSQL versions 11 and earlier, showing how they can disable query optimization.
A deep dive into SQL Server Columnstore Index wait types, explaining their groups and providing setup for analysis.
Columnstore Indexes are now available on the Standard Tier of Azure SQL Database, enabling better compression and performance for data warehousing.
A guide to monitoring and managing PostgreSQL database connections, including interpreting connection states and using timeouts.
A guide to using the new 'Compare ShowPlan' feature in SQL Server Management Studio 2017 to analyze and contrast SQL execution plans.
A primer on PostgreSQL connection pooling, covering framework-level and standalone poolers to optimize database performance and manage connections.
Analyzing MongoDB query performance using $exists operator and the impact of indexes on large datasets.
A guide to using EXPLAIN and EXPLAIN ANALYZE in PostgreSQL, including JSON output and visualization tools for query execution plans.
Explains how to implement database connection pooling for Django applications using PostgreSQL to improve performance.
A guide for developers on monitoring and improving PostgreSQL database performance, covering cache hit rates and index usage.
A technical deep-dive into making Partition Change Tracking (PCT) refresh with partition truncation work correctly for Materialized Views in Oracle 11g.
Explains why average I/O throughput metrics from AWR snapshots can be misleading for capacity planning, using real database examples.
A technical guide on optimizing SQL queries with wildcard-prefixed LIKE conditions using indexed computed columns for better performance.
Compares three methods for passing multiple IDs to a SQL Server stored procedure: CSV lists, XML, and Table Valued Parameters.
Analysis of a now-removed blog post containing performance results from an Oracle Exadata V2 proof-of-concept test.
