Marking a Filegroup Read Only

Read only filegroups are great for adding extra protection to data that should not change, and it saves a bit of overhead because it doesn't to be locked during queries. It's an easy technique to apply, with only one small gotcha!

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Don Weigend on 12/3/2009

Good to know about file groups being inadvertently changed when adding a clustered index. Thank you for the tip!

ka5angel on 12/4/2009

More info about what happens with data in table will be useful.

lakshmi on 12/4/2009

its very nice

Craig Petrosky on 12/4/2009

thanks for the warning about this Gotcha!

Paul Hunter on 12/5/2009

The best part of the video is that the filegroup for the clustered index determines on which filegroup the table rtesides.

Luis Ramos on 12/7/2009

Cool video, thanks for sharing!

32B941FBF4 on 12/12/2009

Thanks for the effort to create these lessons.

aks on 12/28/2009

Informative. Didnt know this.Thnx. :)

A Alagu Ganesh on 2/10/2010

Good

Ravi Raj on 6/29/2010

good one

Richard Leaver on 8/3/2010

This is the same video as Assigning a Clustered Index to a Filegroup

lucas on 1/19/2011

This is the same video as Assigning a Clustered Index to a Filegroup