(Carlos Sierra) I recently saw a post with this title “Oracle Queries are taking different Plans” and since there was a lot of guessing I suggested to use SQLTXPLAIN and find there the root cause. For some reason or another the thread is still open after 20 days, and the guessing continues.
Author: SSWUG Research
Oracle SQL Profile Internals
(Andy Baker) It is very easy to pick a piece of poor performing code either by SQL text or SQL ID and then execute the Oracle SQL tuning advisor against that code. When a SQL profile is recommended though, how many people know what has actually been suggested by the profile internally?
AngularJS Abstractions: Directives
(K. Scott Allen) Directives are one of the lynchpins that make AngularJS work, and also make the framework nice to work with.
A LINQ Style Operator to Set the Length of a Sequence
(Richard Carr) Sometimes it is necessary to modify the length of a sequence of values to achieve a fixed length. This may require that values at the end of the sequence are omitted or that new elements are added to achieve the desired length.
SQL SERVER – CASE Statement/Expression Examples and Explanation
(JAINIK PATEL) CASE expressions can be used in SQL anywhere an expression can be used. Example of where CASE expressions can be used include in the SELECT list, WHERE clauses, HAVING clauses, IN lists, DELETE and UPDATE statements, and inside of built-in functions.
DB2 Locking, Part 8: LOBs and Locking
(Craig S. Mullins) When a row is read or modified in a table containing LOB columns, the application will obtain a normal transaction lock on the base table. The actual values for (most) LOBs are stored in a separate table space from the rest of the table data.
Referencing ColdFusion Query Columns In A Loop Using Both Array And Dot Notation
(Ben Nadel) This is a super short blog post, and might be completely obvious to most people; but, I know that my understanding of ColdFusion query column references has evolved over time, so I thought there might be some people who don’t know this yet.
IBM BLU
(Curt Monash) I had a good chat with IBM about IBM BLU, aka BLU Accelerator or Accleration. BLU basics start:
XML versus JSON: Parsing in PHP and Javascript
(kdoyle) Learn how to parse XML and JSON with PHP and Javascript. This video is is hosted by LearnToProgram instructor Connor Denman.
Passing data from a Roxy app to a JavaScript widget…
(adamfowleruk) This is a quick post to show how to pass information in to a JavaScript widget from a Roxy application…