A collection of questions and answers about SQL, SAP HANA, and data modelling.
How to make HANA process more than 2bn records without partitioning? No average feat!
You think scalar user-defined-functions are slow in HANA?
I show you how to fix that!
Learn something about DBeaver and get free disk space – for FREE!
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.
In which I analyze why a SELECT takes longer when the primary key column is included…
In which I try out something seemingly simple and chase problems down a rabbit hole.
hana.ml.r library for R on macOS is not for the casual user…
Note-To-Myself: solution for “”java.lang.NoClassDefFoundError: javax/xml/soap/SOAPException” error.” with SAP HANA Studio on macOS.
A small function to implement the IF EXISTS option for DDL commands in SAP HANA.