SAP HANA

Getting data into HANA – the easy way

04/09/202004/11/2020
miscellaneous, SAP HANA

Loading data into SAP HANA the super easy way. A click-through. How to use DBeaver to load huge CSV data files quick without any coding.

What is CPB+-Tree in SAP HANA?

07/08/202012/08/2020
SAP HANA

Ever wondered what a CPB+tree is and what it does in SAP HANA? This post has the answer for you.

SAP Online Track 2020

02/06/202020/09/2020
ABAP, SAP HANA, SQL

The SAP Online Track event was a major success.
Find my talk “If your SQL reads like Assembler you’re doing it all wrong.” here.

Find the ONE … or the other

27/04/202006/05/2023
ABAP, SAP HANA, SQL

Some “finger-exercises” in data modeling, SQL programming, and making sense of ABAP design decisions.

Using new features not supported?!

04/04/202020/12/2022
SAP HANA, SQL

What do you do when HANA tells you that the new feature you want to use is actually not supported?
This post has an answer for that.

Matchmaker – quick quick?

26/03/202006/05/2023
SAP HANA, SQL

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.

Matchmaker

26/03/202006/05/2023
SAP HANA, SQL

Finding alternative order-documents where the lineitems match a certain percentage of a reference document? In SQL? With no cursors? See how it’s done!