Is it possible to make any table read only? Well, not directly but you can for sure do that by making filegroup read only. Let us learn.
Feedback Request – COUNT and SUM Videos
I have recently released a few SQL in Sixty Seconds Video and I would like to get your feedback about them. Give your feedback on COUNT and SUM Videos
SQL SERVER – Find Business Days Between Dates
I often receive a very common question during my Comprehensive Database Performance Health Check about how to find Find Business Days Between Dates.
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.
June 2021 Summary for SQL in Sixty Seconds
It seems that YouTube is now gaining more traction than text-based blogs. Let us see June 2021 Summary for SQL in Sixty Seconds.
SQL Server – Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1)
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.