Explores the new online rebuild feature for Clustered Columnstore Indexes in SQL Server, detailing its significance and testing methodology.
Author shares excitement about being selected to speak at PASS Summit 2018 on SQL Server Columnstore index selection.
Explores how to speed up MongoDB's $facet aggregation stage using parallel processing for faster data analysis.
Explains performance issues with standard UUIDs in MySQL and presents an optimized solution using binary storage and bit-shifting.
A technical guide explaining how to use Django's prefetch_related to solve the N+1 query problem and optimize database performance.
A comprehensive guide to diagnosing and fixing OBIEE (Oracle Business Intelligence) performance issues, covering testing, caching, and optimization.
Explores SQL Server 2016's In-Memory OLTP enhancements, including new constraints, encryption, and operational analytics capabilities.
Technical guide on optimizing Drupal performance by managing database indexes, queries, and removing unused modules.
Introduction to Drupal performance tuning, focusing on database optimization, query analysis, and monitoring tools for better web application speed.
A guide on replacing Drupal's resource-intensive database logging with the Syslog module for better performance.
Explains how to use PostgreSQL expression and functional indexes to optimize queries using built-in functions or custom JavaScript functions.
A guide to using MiniProfiler for performance profiling and identifying bottlenecks in ASP.NET MVC applications, focusing on database queries and server-side timing.
A technical guide on reducing SQL database size by normalizing repeated data like IPs and User Agents into separate relational tables.
Explains the ambiguous GATHER AUTO option in Oracle's DBMS_STATS for gathering database statistics, clarifying its behavior compared to STALE and EMPTY.
Argues against using Oracle's automatic optimizer statistics collection in data warehouses, advocating for manual stats management as part of ETL processes.
A technical guide on safely converting a SQL Server primary key index from nonclustered to clustered (or vice versa) using a temporary unique constraint.
A developer details optimizing a Django view to analyze chat log data, reducing execution time and database queries.
Technical analysis of optimizing an Identity Mapper in Django, focusing on query reduction and in-process caching strategies.
Explains how to create an efficient timeline view in Django by merging multiple sorted querysets to minimize database queries.
