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.
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.
SQL SERVER – COUNT(*) and Index Used – Part 2
Yesterday I wrote a blog post on the topic SQL SERVER – COUNT(*) and Index Used, lots of people asked me to follow up question.
MS Access – Count Distinct Values
I love answering random questions and particularly when they are from my paying clients. Let me answer about MS Access and Count Distinct Values.