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.
SQL SERVER – Index Scans are Not Always Bad
Are Index Scans Bad? The answer No. Index Scans are Not Always Bad. This was in-depth discussed with my client during the Health Check.