Separate business logic from tables and avoid dynamic SQL
You want to apply your business logic to multiple tables in your DB but don’t want to use dynamic SQL? Good on you! Here’s how.
performance
Why are your scalar UDFs slow? (mine aren’t)
You think scalar user-defined-functions are slow in HANA?
I show you how to fix that!
How to engineer your DB code
See how to choose between different implementation options for your DB code like an engineer.
Also: JMeter, htop, and MapMerge programming.
What a 10x network speed difference looks like
Get 10x better network speed improvement by using a crazy little piece of equipment. It looks like this…
What is CPB+-Tree in SAP HANA?
Ever wondered what a CPB+tree is and what it does in SAP HANA? This post has the answer for you.
Find the ONE … or the other
Some “finger-exercises” in data modeling, SQL programming, and making sense of ABAP design decisions.
Matchmaker – quick quick?
You’ve come up with a clever SQL to solve a problem but now you want to make it fast?
No worries! This post shows how I shaved off 50% runtime and memory by copy & paste.
SAP Inside Track #sitMEL – Full Day Event in Melbourne
Looking for the content of Lars’ presentation from #sitMEL-2020? Look no further, it’s all here.
One in a Million
In which I analyze why a SELECT takes longer when the primary key column is included…
How to know “all these things”
There is one predominant reason for 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 requires a form of end-to-end understanding with different levels of detail insight on how a query from a client application is processed by … How to know “all these things”