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!
In which I deal with non-obvious type conversion problems and NULLs.
How do implement unique constraints for only some of the table entries in SAP HANA.
Most folks working with SQL DBs for a while will likely come to see how beginners in this area struggle with “declaritive code” and “tell the DB what you want not how to do it” In my experience, this issue stems partly from the way SQL is tought – examples are often way too simplistic … New year, same issues and some tips.
About a year ago I answered a question on the SAP Community Q&A site and have it on my posts-to-write list ever since to turn it into a blog post. I feel that I learn a lot from seeing applied examples of concepts and rules – for example from this great presentation from Kevlin Henney … SQL refactoring example
A small function to implement the IF EXISTS option for DDL commands in SAP HANA.