Data, Process, Insights & things I write about
Apart from writing blog posts I have written answers to many questions on several Q&A sites like StackOverflow and SAP Community. Some of those answers received good feedback and/or the answer surprised me once I worked… Read More » Answers Pinboard
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 the DB what you want not how to do it” Read More » New year, same issues and some tips.
There is one predominant reason why databases and database technology get a spot in the conversation of “the business”: performance. Understanding system performance and coming up with ideas for improving it typically… Read More » How to know "all these things"
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 been reached. Looking back on the messages I worked on I found a very clear pattern, when… Read More » How most BW performance support messages are solved
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. The customer complained about short dumps with the infamous… Read More » SAP Support case “FOR ALL ENTRIES disaster”
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 of the partitioning feature for an SAP BW installation. Read More » Partition count contest!
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 we don’t know that get us into trouble. It’s the things you know that just ain’t so." Read More » Short note on Line Item and High Cardinality dimensions
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 by a customer. So, what is the customer complaining about? What does he mean… Read More » Question to SAP Support “Why is partition pruning not working in my BW on Oracle?”
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 me). This alone is not worthy of writing even a short note, as it… Read More » “Things change for the better” or “How I enhanced the Oracle DBMS software”
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 super-short-blog post about a pretty common BW-on-Oracle performance hunch:… Read More » BW on Oracle: a performance hunch I see more and more often…