Sql

A common requirement for SQL DB modeling is to have something that could be called conditional unique constraint. The idea is that certain combinations of column values should only occur once if at all, while other… Read More » Conditionally unique

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” Read More » 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… Read More » SQL refactoring example

A recurring question of folks using SAP HANA is how to only run a DROP command for objects that actually exist in the database. One could argue that the effect of executing DROP does not depend on whether the object to… Read More » IF EXISTS would exist

There was an interesting (aka nerdy) question in the SAP Community Q&A the other day: “Are SQLScript and HANA SQL Turing complete?” I took a swing at it and the following is my result (a slightly edited version of my… Read More » Is SAP HANA SQL/SQLScript Turing complete?

Have you been using the ISNUMERIC function of MySQL, MS SQL Server or PostgreSQL and wondered what to use in SAP HANA instead? If so, this is the blog post for you. Read More » What's your number?

Hey there! I recently presented a short session on my experiences with developing and debugging non-classic-SAP HANA solutions at the Leading Insights conference in Melbourne (27./28.3.2017). And since the slides are… Read More » Eco-friendly slide recycling with HANA

Based on SAP HANA SPS 11 Update 1.6.2017 # Retesting the APPLY_FILTER() approach on rev. 112.07 showed that it is now possible to simply hand APPLY_FILTER() an IN condition with a list of integers. Read More » On multiple mistakes with IN conditions

In Quick notes during a fiddle-session I played around with a table that contained all possible values for a date column. To fill it I used a FOR LOOP with an INSERT and a COMMIT every 10000 records. That took 9:37… Read More » Fiddle riddle – Amazing: stuff gets faster and takes less space!

For a while now I am working as a Solution Architect for the SAP Custom Development organisation. This is the team you’d call when you want custom-built solutions that perfectly fit into your standard solution landscape.… Read More » Quick notes during a fiddle-session