New answers tagged


I was able to drop the filegroups after dropping partition schema and then dropping partition function. DROP PARTITION SCHEME <<PartitionSchemeName>>; DROP PARTITION FUNCTION <<PartitoinFunctionName>>; ALTER DATABASE DBNAME REMOVE FILEGROUP PartitionFG


Can you post the result of the following sql statement? SELECT o.[name], o.[type], o.[type_desc], i.[name], i.[index_id], f.[name] FROM sys.indexes i INNER JOIN sys.filegroups f ON i.data_space_id = f.data_space_id INNER JOIN sys.all_objects o ON i.[object_id] = o.[object_id] WHERE i.data_space_id = f.data_space_id AND i.data_space_id > 1 GO


The clustered index structure is the table in SQL Server. In order to remove a filegroup, you first need to remove all data from the filegroup. There are several ways of doing that, including using the GUI, like this: Right-click the table, and choose "Design" Right-click the "empty" area of the top design panel, and choose "Properties" like this: ...


Your question is a bit wide-ranging, however some of the main points include the following. Multiple file groups, in general: can be a performance improvement, assuming they are physically isolated. Typically, you might create one filegroup for clustered indexes, one filegroup for non-clustered indexes, and one filegroup for heaps. Or you might create ...

Top 50 recent answers are included