One question that kept on coming up was SUM(1) vs COUNT(*) – Performance Observation. Well, let us see that today.
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.
SQL SERVER – Identity Column is Difficult to Remove
I discuss this during  Comprehensive Database Performance Health Check. It is true that the identity Column is Difficult to Remove.