![[Video] Office Hours: Long Answers Edition](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/thumbs/article-a9f3e37652de-full-5d20e9da.webp)
Brent Ozar answers database questions on HADR_SYNC_COMMIT waits, indexing strategies, RCSI, and SQL Server comparisons.
T-SQL Tuesday roundup on warning signs of bad SQL queries, including WHILE loops, cursors, functions, and DISTINCT.
Learning practical tips for running SQLite in production, including ANALYZE for query performance and handling cleanup operations.
Techniques for achieving partition pruning in PostgreSQL when filtering by non-partition key columns.
Optimizing a slow CockroachDB query listing users with SELECT DISTINCT, investigating performance issues.
Investigating and fixing a slow CockroachDB pagination query that reads millions of rows but only returns 100.
Optimizing a slow password reset query in CockroachDB, reducing row reads from 700k to 10.
Best practices for managing Apache Iceberg snapshot expiration in data lakehouses to optimize query performance and metadata size.
Explains five ways Apache Iceberg table storage degrades over time, including small files, orphan files, and metadata bloat, with detection methods.
Explains how Row-Level Security in Azure SQL can cause single-threaded queries and suggests indexing as a performance solution.
Explains why logical reads are not repeatable when using columnstore indexes in SQL Server, challenging a common tuning assumption.
Explores creative PostgreSQL optimization techniques beyond standard indexing and query rewriting, focusing on constraint exclusion and function-based indexes.
A technical analysis of missing features and wishlist for SQL Server Columnstore Indexes as of 2026, focusing on performance and functionality gaps.
Explores how metadata in Parquet files improves data efficiency and query performance, covering file, row group, and column-level metadata.
Explains the differences between MongoDB's $match operator and find() method, including performance benchmarks and use cases.
Analyzes how medium-sized text fields impact PostgreSQL query performance through the TOAST storage mechanism.
Explores SQL Server 2019's session context functions and their unexpected impact on query parallel execution plans.
Explains the internal workings of SQL databases, covering data structures like tables, indexes, rows, and pages for both storage and querying.
Explores compatibility of Columnstore Indexes with new features in SQL Server 2019, including Approximate Distinct Count and Scalar UDF Inlining.
Explores the preview feature of ordered Clustered Columnstore Indexes in Azure SQL Data Warehouse, testing syntax and performance benefits.
