Introduction I must admit I have a weakness for British humour. When I had to cope with leading zeros in business keys some time ago, I spontaneously came up with the title of this post, not knowing that it would serve as such. For those who do not know, "Meetings, bloody meetings" is a British comedy training film in which John Cleese plays a main role. It was...
Read MoreIntroduction This weeks post is about the LoadDate and LoadEndDate. Actually there are two things to be nerdy on: End dating without gaps Getting the best value for bytes on DATETIME2 precision By the way, these topics apply to SQL Server, the examples are made using SQL Server 2014. 1. End dating without gaps How end dating works In a Data Vault Satellite, different subsequent versions of a row in the source...
Read More
