Claus on Code

A data dudes random musings about code, bugs, products, life etc.

  • SQL TIP -> Recursive CTEs

    This morning I  had to do some recursive common table experessions. It is acctually relativly simple to do. A common scenario: We have a parent child relation in a selfreferencing table. That is common when we have an employee manager relationship or organisation relationship. Let’s just look at  the  employee manager relationship. Let’s create an… Continue reading

  • Prepopulate a table with data in SSDT

    The new database project in SSDT, is truly a great tool. It is not perfect thou, and one of its shortcomings, is that there is no out of the box way, to define some static/initial data in in a project, when you deploy it. In all the projects I do, I always want to have… Continue reading

  • Analysis services -> Clear Cache

    Just a short note about analysis services and its cache 🙂 One of the reasons for analysis services fast respond time is its cahce. But what if you want to test a query without using the cache? Well, just use this XMLA Script: Also, if you do partial processing, the cache, can in some cases… Continue reading