What we're considering doing is adding a filegroup to the database and moving the file data to that separate filegroup, so that as part of the demo/stage/dev refreshes, we can just grab the ...

As mentioned in my post on VLDBs, one of the key pieces of a high performing solution is the use of Read-only Filegroups. If a significant part of your data is not changing, then why not tell SQL ...

The complexity of administering Filegroups combined with the removal of the 2GB file size limit using NTFS, led to its decline in favor of hardware RAID. You could get plenty of performance and ...