It seems lots of people like to watch videos over reading blog posts. The other day I posted a blog post SQL SERVER – Making Table Read Only via FileGroup. 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?
It is for sure possible to make read-only tables. There are many different methodologies, the one, I have used is very simple and I have been using it for a while with my clients. Here we create a read-only filegroup so every table which existed on it, automatically becomes read only.
If you are looking for the script used in this video, I have it over here.
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.
- 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
- 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)
2 Comments. Leave new
First time poster very long time reader. I love your site and its my go to for many SQL inquiries/research. It took a lot of time but I have gone back and viewed every post since the beginning and it was worth it, found some good info that is still usable today.
The videos are good and well done but many times I just want to be able to quickly read a page and see the information without having to watch a video (plus many times I may not have audio ready or be in spot I can listen, but I still want the info).
For the articles you do video’s for if you could write it up in text like other posts that would be helpful to some like me who like reading vs watching videos or are not in a place to watch a video at the time.
Thank you so much. All the blog has a link to the text like stories for the same blog.