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.
You think scalar user-defined-functions are slow in HANA?
I show you how to fix that!
See how to choose between different implementation options for your DB code like an engineer.
Also: JMeter, htop, and MapMerge programming.
Get 10x better network speed improvement by using a crazy little piece of equipment. It looks like this…
Ever wondered what a CPB+tree is and what it does in SAP HANA? This post has the answer for you.
Some “finger-exercises” in data modeling, SQL programming, and making sense of ABAP design decisions.
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.
Looking for the content of Lars’ presentation from #sitMEL-2020? Look no further, it’s all here.
In which I analyze why a SELECT takes longer when the primary key column is included…
How to learn about foundational techniques used in DBMS? This post provides some pointers to great free resources.