Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Tag: filegroups
Partition : understanding files and file groups
Question : We are trying to partition a large history table. Being new to partitioning, I was trying to understand […]
File Group Association while Snapshop Replication
Question : I want to know how can I save filegroup structure during snapshop replication in SQL Server? Does this […]
Multiple filegroups vs. multiple files in a single filegroup
Question : From what I’ve read online, it seems that multiple filegroups offer only two advantages over having multiple files […]
What happens when you create the primary key of a table on a different filegroup?
Question : Creating a table on a different filegroup is absolutely no problem when using Sql Server. create table common.test […]
Does spreading table data across multiple files (in the filegroup) improve performance?
Question : From the product documentation on filegroups: For example: Data1.ndf, Data2.ndf, and Data3.ndf, can be created on three disk […]
Database Migration – Create New Filegroup and Move Objects
Question : We have built a new SQL Server Database server instance. I am migrating our databases from existing instance […]
How to fill/insert fake data into a MS Sql Server
Question : I’m trying to test out some configuration settings for an MS Sql Server FILEGROUP and to do this […]
Can you create a new filegroup for a table in a database that is live?
Question : I have a SQL Server 12.0.5223.6 instance with a database on it. I’m wondering if I can create […]
Where would the table data be if you had 3 filegroups, 2 with tables and 1 with all indexes?
Question : I’m studying filegroups at the moment as I haven’t used them much before. A class I’m taking mentions […]