I had to help a collegue out today. He had to delete about 12 million rows on a 13 billion row table. And his statement (delete from [table name] where spec_id = 1) never got anywhere. First thing i tried was to encapsulate the statement in a transaction. This transaction was put within a while … Doorgaan met het lezen van Deletes on large table

Blog number 5 and already looking back? Sure, to appreciate the future, you have to know the past. Or something like that 😉 2018 has been a very, very interesting year. The first half started out quite normal, besides writing an advanced SQL training that lasts two days. I don't know how i got round … Doorgaan met het lezen van 2018 review

It's been too long since my last blog, time for a new one! I got an email today from docker with an invitation for a webinar. As i'm interested in the subject, i took the invitation and tonight (20:00 local time) the webinar started. It started with some survey results from Forrester about the usage … Doorgaan met het lezen van An evening of Docker