Let us learn today how to CONVERT Empty String To Null DateTime. While I focus on SQL Server Performance Health Check, let us learn about it today.
SQL SERVER – List Service Broker Queue Count
Clients ask me questions, I try my best to help if I know the answer. Recently I was asked if I know the how-to List Service Broker Queue Count.
SQL SERVER – Enable or Disable All Triggers
As soon as we did disable all triggers on the tables, we were able to see a huge performance improvement. Let us learn how we can do it.
SQL SERVER – Function to Calculate Simple Interest
It was very surprising that they would write a complicated function. Let us see a very simple way to write Function to Calculate Simple Interest.
SQL SERVER – Difference Between Count and Count_Big
Let me answer you first – there is no difference between Count and Count_Big in terms of functionality. They are almost the same.
Bitwise Puzzle – SQL in Sixty Seconds 160
Many did not believe in the real world and based on the request, I have made the recent video on the same topic of the bitwise puzzle.Â
SQL SERVER – Change Join Type for Query
“Can I Change Join Type for Query?” I was recently asked this during  Comprehensive Database Performance Health Check. Of course Yes!