The challenge I face is that often DBAs ask me to prove that indexes are really not used by queries. Let us learn about Queries Using Specific Index.
Read Only Tables – Is it Possible? – SQL in Sixty Seconds #179
After reading it, lots of people asked me if I can make a video on this topic. Of course, here we go, Read Only Tables – Is it Possible?
One Scan for 3 Count Sum – SQL in Sixty Seconds #178
Well, the answer is pretty straight forward and that is what we are going to see in today’s video of One Scan for 3 Count Sum.
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.
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.
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.