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