Here are the blog posts associated with them.
One Scan for 3 Count Sum – SQL in Sixty Seconds #178
SUM(1) vs COUNT(1) Performance Battle – SQL in Sixty Seconds #177
COUNT(*) and COUNT(1): Performance Battle – SQL in Sixty Seconds #176
COUNT(*) and Index – SQL in Sixty Seconds #175
Well, that’s it. Now it is time for you to help me out. Watch the video and give me feedback about which one you liked the most and if you are in good mood, you may also post the reason for the same and tremendously help me.
Well, that’s it for today. If you liked this video, please do not forget to subscribe to my YouTube Channel – SQL in Sixty Seconds.
Here are my few recent videos and I would like to know what is your feedback about them.
- Index Scans – Good or Bad? – SQL in Sixty Seconds #174
- Optimize for Ad Hoc Workloads – SQL in Sixty Seconds #173
- Avoid Join Hints – SQL in Sixty Seconds #172
- One Query Many Plans – SQL in Sixty Seconds #171
Reference: Pinal Dave (http://blog.SQLAuthority.com)