sql

Matchmaker – quick quick?

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

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!

SQL refactoring example

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