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.
One of the most popular questions I received during my Comprehensive Database Performance Health Check is Finding Queries Using Particular Index.
Today we will take the same conversation to the next level by discussing Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1).
One question that kept on coming up was SUM(1) vs COUNT(*) – Performance Observation. Well, let us see that today.