https://techcommunity.microsoft.com/blog/sqlserver/read-only-filegroups-and-locking/383201
Read-Only filegroups and Locking | Microsoft Community Hub
Mar 23, 2019 - First published on MSDN on Jan 08, 2007 I recently saw a newsgroup post that sort of implied that accessing data residing on read-only filegroups can save...
read onlymicrosoft communitylockinghub
https://learn.microsoft.com/en-gb/sql/t-sql/statements/alter-database-transact-sql-file-and-filegroup-options?view=sql-server-ver15&preserve-view=true
ALTER DATABASE File and Filegroups - SQL Server (Transact-SQL) | Microsoft Learn
Update a database's files and filegroups using Transact-SQL.
sql serveralterdatabasefiletransact