It seems that YouTube is now gaining more traction than text-based blogs. Let us see June 2021 Summary for SQL in Sixty Seconds.
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).
SUM(1) vs COUNT(1) Performance Battle – SQL in Sixty Seconds #177
Based on my recent two videos, I got lots of questions about SUM(1) vs COUNT(1) Performance Battle. Let us see that in today’s video.
Free Webinar – SQL Performance Monitoring with Wait Statistics Scripts
This blog will share details about the free webinar –Â SQL Performance Monitoring with Wait Statistics Scripts. Let us discuss it today.
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.Â
COUNT(*) and COUNT(1): Performance Battle – SQL in Sixty Seconds #176
COUNT(*) and COUNT(1): Performance Battle – which one is better for performance? I got this question after watching my previous video.