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.
SQL SERVER – COUNT(*) Collection of Articles
Today we are building a Collection of Articles that have recently generated interest on the blog as well as on the YouTube channel – Â SQL in Sixty Seconds.Â
SQL SERVER – COUNT(*) and Index Used
DBA suspects those operations are using lots of clustered index scans. Let us discuss today COUNT(*) and Index Used. Let’s learn.