Rittman Mead - Delivered Intelligence

And relax… Just finished the second of my two Desktop Conference 2006 presentations, this time on Oracle OLAP Best Practices. There were more technical problems as the start again, just as I was about to start I was asked to move to a different conference ID (i.e. virtual "room") and only about half of the [...]

Well I’ve just finished my first presentation for the Desktop Virtual Conference 2006, on XML Publisher. It was a bit strange presenting it actually, there’s no feedback during the session from the audience and no visual clues as to whether you’re doing OK or not. At the start of the talk I told the organiser [...]

"Faster Batch Processing" : "When you need to load millions of rows of data into a table, the most efficient way is usually to use an INSERT, UPDATE, or MERGE statement to process your data in bulk. Similarly, if you want to delete thousands of rows, using a DELETE statement is usually faster than using [...]

I’ve finished the presentations now for the Desktop Conference 2006 next week; the one on XML Publisher is the one that I gave the other week at the UKOUG BIRT SIG (with the addition of a XML Publisher Desktop demo), whilst the OLAP Best Practices one is a development of the two articles I did [...]

Yesterday I had a small rant about the use of case statements in where clauses. In a reply to this parkerpg suggested this was perhaps generated by the use of query environment such as Cognos. In this case we are not using Cognos but I think the principle holds good and we are seeing inappropriate [...]