Skip to content

performance analysis

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!

One in a Million

Inspector Columbo - Just one more thing....

In which I analyze why a SELECT takes longer when the primary key column is included…