Let me answer you first – there is no difference between Count and Count_Big in terms of functionality. They are almost the same.
Learning Resources I Use and Recommend (Updated: April 2020)
In today’s blog post I will be sharing a few of the learning resources which I have been using to further train my skills.
Android Greenbox Around Icon – Unable to Scroll
I thought it might be just a temporary thing and I had restarted it but that was not the case. In My android phone, I had a Greenbox Around Icon.
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!
Install Python3 on Linux
My major focus is always on SQL Server. I know a little bit about other technology as well. It is very straightforward to install Python3 on Linux.
SQL SERVER – Change Password at the First Login
Just like many other databases and applications, SQL Server also supports the feature to change password at the first login.
SQL SERVER – AdHoc Queries and Optimize for Adhoc Workloads
Discussion with a client during the Comprehensive Database Performance Health Check. The topic is AdHoc Queries and Optimize for Adhoc Workloads.