This puzzle, I have discovered accidentally. In one of the recent project, I had to display two dates next to each other. Now, when I was doing this, I accidentally did a mistake while I was typing that out. Indeed, this puzzle about strange results when adding two dates.
In the last puzzle, user had to write the shortest code to produce 0. I have received around 700 valid answers and while reading through the answers, I had a blast. I personally learned quite a lot from just administrating the quiz. Since that puzzle, I have received quite a few emails requesting to come up with next puzzle.
If you have not understood what I am going to talk in this blog post by just reading the title, I think you are a normal human like me. Just the other day I received an email from a blog reader with subject line as “Select Unique Data From a Column Exist in Two Different Table”.
Puzzle: Write a Shortest Code to Produce Zero.
It has been a while we have seen a puzzle on this blog and I keep on receiving emails and comments that you all would love to see one more puzzle. Let us see a new puzzle “Incorrect Results with Decimal”.
There are many times when a DBA should work like a detective and find the cause of the issue which is reported by various teams. Sometimes it is an application team, sometimes an infrastructure team and sometimes its own learning. I always believe looking at the data points and finally connect the dots to make a story. Let us learn about why we have audit trace in the data folder.
When you see something not behaving the way normal way, either it must be magic or in software terms it is an error or bug. This blog was inspired by someone who caught me unaware with this challenge that it took me by surprise. I didn’t know how to solve it and it took me close to 10 mins before realizing what was happening behind the scenes. Let us see the puzzle about Why does sp_spaceused Show No Values?