A collection of questions and answers about SQL, SAP HANA, and data modelling.
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.
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!
Doing calculations with dates in your queries? Better read this post and make sure your code does what you think it does.
How do implement unique constraints for only some of the table entries in SAP HANA.