SQL – MARCOSIKKENS.NL

Datetime precision in SQL server

marcosikkens SQL June 2, 2019 June 2, 2019 Leave a comment

We recently had a problem at work where we inserted a data in a very short amount of time. But then we noticed something strange with the inserted data, because after querying a lot of insertion times where the same but we were (kinda) sure that it shouldn’t be the …

Tracking table changes in SQL server

marcosikkens SQL March 17, 2019 March 17, 2019 Leave a comment

A couple of months ago I needed to write an application that synchronizes data between systems. After the initial sync which were quite a few rows I didn’t want to sync the complete database every few days so I needed another solution. Then i saw a colleague using SQL server …