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.
COUNT(*) and Index Frequently Asked Questions
However, before you read today’s COUNT(*) and Index Frequently Asked Questions I suggest you watch the video COUNT(*) and Index.
COUNT(*) and Index – SQL in Sixty Seconds #175
Earlier I wrote two blog post on the topic of COUNT(*) and Index and today I have to build a video on that topic as many of you really wanted.