A developer shares 10 essential PostgreSQL features and tips for 2016, including CTEs, performance tuning, and configuration.
Explores how MongoDB's BI Connector pushes SQL WHERE clauses and projections down to the database as an aggregation pipeline for efficient querying.
Part 3 of a series on building Stack Overflow's tag engine, focusing on implementing complex boolean queries using bitmap indexes and compression.
Explains why SQL Server's dm_exec_query_plan returns NULL for stored procedures with conditional logic and temp tables, and how to diagnose it.
Introduction to Drupal performance tuning, focusing on database optimization, query analysis, and monitoring tools for better web application speed.
Explains how to use PostgreSQL's CTEs (WITH clauses) to write more readable, composable, and maintainable SQL queries.
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.
A collection of practical tips and guides for effective indexing in PostgreSQL, covering unused indexes, costs, and performance considerations.
A developer shares common SQL bad habits like using column numbers in ORDER BY, implicit joins, and lacking comments, with examples and better practices.
A developer shares his preferred method for working with PostgreSQL, advocating for the psql command-line tool and sharing key tips and configurations.
A guide to optimizing PostgreSQL queries using pg_stat_statements, focusing on analyzing query performance and improving indexes.
A developer shares his approach to writing clean, readable SQL with practical examples and best practices for structuring queries.
A guide for developers on monitoring and improving PostgreSQL database performance, covering cache hit rates and index usage.
Explains when to use temporary tables instead of table variables in SQL Server for significant query performance improvements.
Analyzing and optimizing slow date range queries in Apache Jackrabbit within Hippo CMS to improve performance and reduce memory usage.
A technical guide on optimizing SQL queries with wildcard-prefixed LIKE conditions using indexed computed columns for better performance.
Fixes an NHibernate.Linq bug where queries with the same alias on different association paths produced incorrect results.
How rewriting a MySQL query to use indexes properly improved performance from 10 seconds to 0.03 seconds.
A technical note on how Django's self-referencing ForeignKey fields can cause unnecessary SQL JOINs and a workaround using the extra() method.
