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 – 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.
SQL SERVER – COUNT(*) and Index Used
DBA suspects those operations are using lots of clustered index scans. Let us discuss today COUNT(*) and Index Used. Let’s learn.
Index Scans – Good or Bad? – SQL in Sixty Seconds #174
Index Scans – Good or Bad? Lots of people ask about this question and I have built a blog post on the topic – SQL SERVER – Index Scans are Not Always Bad.
SQL SERVER – Index Scans are Not Always Bad
Are Index Scans Bad? The answer No. Index Scans are Not Always Bad. This was in-depth discussed with my client during the Health Check.