SUM(1) vs COUNT(1) Performance Battle – SQL in Sixty Seconds #177

SUM(1) vs COUNT(1) Performance Battle - SQL in Sixty Seconds #177 177-SomeOne-main-yt-800x450 Based on my recent two videos COUNT(*) and Index – SQL in Sixty Seconds #175 and COUNT(*) and COUNT(1): Performance Battle – SQL in Sixty Seconds #176, I got lots of questions about SUM(1) vs COUNT(1) Performance Battle. Let us see that in today’s video.

I personally, had great fun building this video. You can watch the video over here.

You can get the script used in this video from here: SQL SERVER – SUM(1) vs COUNT(*) – Performance Observation

Well, that’s it for today. If you liked this video, please do not forget to subscribe to my YouTube Channel – SQL in Sixty Seconds.

Here are my few recent videos and I would like to know what is your feedback about them.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Exit mobile version