Analyzing and optimizing slow date range queries in Apache Jackrabbit within Hippo CMS to improve performance and reduce memory usage.
A guide to forcing Oracle 11g to use a specific execution plan for a problematic SQL query using SQL Plan Baselines.
SQL queries to analyze and identify performance bottlenecks in Oracle Data Integrator (ODI) batch jobs with many tasks.
A detailed review of the SQL Server MasterClass 2010 event, covering sessions on DevOps, myth-busting, recovery, and GUID performance.
A personal recap of attending SQLBits VI, covering sessions on SQL Server performance tuning, parallel query execution, and the query optimizer.
How to resolve ORA-13757 error when deleting an active SQL Tuning Set in Oracle, including diagnostic queries and cleanup steps.
Oracle's performance recommendations for OBIA 7.9.6, focusing on ETL improvements and hardware sizing.
Explains how to use the SP:StmtCompleted SQL Profiler event to identify slow individual statements within a stored procedure.
A summary of a talk by Spring JDBC lead Thomas Risberg on performance tuning for data access in Spring applications, covering JDBC, transactions, and ORM configuration.
