For the T-SQL Tuesday challenge in June, I took a look at temporal tables. When I was querying the table to show the changes, I found that when I selected from the temporal table to return the history records as well, not all of the rows I expected to see were being returned. My theory was that it may be a timing issue where a date time precision that prevented all of the updates from being written.
As I went through this second look, I realized that my original theory was off. I know it’s not the first time this will happen and it’s not going to be the last. But this is why we blog – to learn from our mistakes, right?