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 attendees on the old room managed [...]

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
to open up the [...]

"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
procedural code. But what if [...]

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 last year for
DBAZine.
If you’re [...]

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 [...]