I understand that there is no one way to describe the CPUs and that is the primary reason, why I get a different answer when I try to get CPU details.
SQL SERVER – OS Threads Used by SQL Scheduler
Today we will answer the question asked by my client during Comprehensive Database Performance Health Check, about OS Threads Used by SQL Scheduler.
SQL SERVER – CONVERT Empty String To Null DateTime
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.