SPN for SSRS
Troubleshooting Kerberos authentication in SSRS due to SPN Continue Reading
Month: September 2016
Gathering Statistics with Option ‘gather auto’
In 12c the parameter options was introduced in gather_table_stats. Unfortunately, it doesn’t work as expected. Continue Reading
Disjunctive Subquery Optimization
Disjunctive subqueries are the subqueries which are applied to the or operator. Alternatively, these queries can be rewritten to use the union all operator which may be a more efficient way to retrieve the records from the database. This blog post compares the efficiency of SQL Server and Oracle optimizer when dealing with the transformations of disjunctive subqueries.
Continue Reading
Table Spool Performance Problem
Table Spool can degrade SQL Server performance. Continue Reading
Nested Loop Join Heuristics
Not always the cheapest execution plan gets chosen. This blog post describes such an edge case in SQL Server and Oracle. Continue Reading