Analyzes the performance difference between SQL's FILTER clause and CASE expressions in aggregate functions, using PostgreSQL benchmarks.
A guide to emulating window functions in MySQL 5.7 using local variables, highlighting the limitations and risks of this approach.
Explains how to use the SQL LATERAL keyword to create local column variables and simplify complex queries, improving readability.
A technical guide explaining how to use the $sort stage in MongoDB's aggregation pipeline, covering single/multi-field sorting, case sensitivity, and memory limits.
Discusses why SQL's SELECT..FROM syntax order isn't a flaw to be 'fixed' by FROM..SELECT, comparing it to logical execution order and language design.
Explores efficient database strategies for fetching large view counts on social platforms, avoiding costly SELECT COUNT(*) operations.
Explains performance issues with OFFSET in database pagination and introduces keyset pagination as a more efficient alternative.
A tutorial on using the $group stage in MongoDB's aggregation pipeline, covering distinct grouping, multiple fields, and accumulator functions with practical examples.
A guide to using the $project stage in MongoDB's aggregation pipeline, covering field inclusion, exclusion, and array operations.
Explores how MongoDB optimizes queries on Views, including filter pushdown and index usage, using a music dataset example.
A guide to converting SQL Server Profiler templates to Extended Events (XEvents) sessions using the SSMS GUI for performance monitoring.
A former Application DBA shares advanced SQL and database optimization techniques for developers, focusing on performance and efficiency.
Explains why LINQ Join is faster than nested loops or Select for merging data in C#, focusing on performance with large datasets.
Tips for using Google BigQuery's public datasets while managing and minimizing query costs, including using the free tier and setting budgets.
A guide to common SQL mistakes and optimization opportunities for developers and data professionals, covering integer division, UNION vs UNION ALL, and query performance.
A technical deep-dive into diagnosing and solving severe performance issues caused by an 'Export to Excel' feature in a Django system.
A detailed overview of the new Database Scoped Configuration options introduced for SQL Server and Azure SQL Database in 2018, leading into 2019.
A technical deep dive into solving PostgreSQL disk space issues by optimizing a deduplication query, focusing on reducing sort key size.
Explores limitations of Batch Execution Mode on Rowstore Indexes in SQL Server, including heuristics and missing operators.
Explores the heuristics and conditions under which SQL Server's Query Optimizer decides to use Batch Mode execution for query processing.
