Another day and another interesting question by a client Do we still get a bad plan after disabling Parameter Sniffing? Yes!
SQL SERVER – Parallelism in Express Edition
Recently a client reached out to me with a very interesting question, why is he not able to see the parallelism in Express Edition. Let us discuss today.Â
SQL SERVER – Dirty Pages vs Clean Pages in Memory
I was asked what is the difference between Dirty Pages and Clean Pages in SQL Server Buffer Memory and which one is better? Let us quickly discuss.
SQL SERVER – Query Cost 100%
How to tune a T-SQL with Query Cost 100%?Â
This is indeed an interesting question and I have received during Comprehensive Database Performance Health Check.
SQL SERVER – Finding Queries Using Particular Index
One of the most popular questions I received during my Comprehensive Database Performance Health Check is Finding Queries Using Particular Index.
SQL Server – Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1)
Today we will take the same conversation to the next level by discussing Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1).
SQL SERVER – SUM(1) vs COUNT(*) – Performance Observation
One question that kept on coming up was SUM(1) vs COUNT(*) – Performance Observation. Well, let us see that today.