Oracle Database
New year, same issues and some tips.
Most folks working with SQL DBs for a while will likely come to see how beginners in this area struggle with “declaritive code” and “tell… Read More »New year, same issues and some tips.
How to know “all these things”
How to learn about foundational techniques used in DBMS? This post provides some pointers to great free resources.
How most BW performance support messages are solved
As the fourth quarter of the year started everybody seems to check the goals that had been set for this year and what has already… Read More »How most BW performance support messages are solved
SAP Support case “FOR ALL ENTRIES disaster”
Last week a colleague from the WHM (data warehouse management) support team called me to get some assistance with a customer message he was processing.… Read More »SAP Support case “FOR ALL ENTRIES disaster”
Partition count contest!
Let’s have a contest! One of my last blog posts started off a discussion (e.g. Bala posted his thought in a blog) about the importance… Read More »Partition count contest!
Short note on Line Item and High Cardinality dimensions
One of the quotes I like most I learned from Tom Kyte from Oracle. It’s one from Artemus Ward: “It ain’t so much the things… Read More »Short note on Line Item and High Cardinality dimensions
Question to SAP Support “Why is partition pruning not working in my BW on Oracle?”
Welcome to the problem As usual understanding, the meaning and the scope of the question is key for the answer to this question, recently filed… Read More »Question to SAP Support “Why is partition pruning not working in my BW on Oracle?”
“Things change for the better” or “How I enhanced the Oracle DBMS software”
Unexpected Behavior Last week during an Oracle workshop with my primary support colleagues in the GSC Ireland I came across something new (at least to… Read More »“Things change for the better” or “How I enhanced the Oracle DBMS software”
BW on Oracle: a performance hunch I see more and more often…
Ok, once again reproducing a problem takes a lot of (waiting-)time for the query to finish. In the meantime I can also just write a… Read More »BW on Oracle: a performance hunch I see more and more often…