Questions tagged [filegroups]
In SQL Server, a filegroup is a logical collection of one or more physical files onto which the database will write.
128
questions
0
votes
1
answer
31
views
Is DBCC CHECKFILEGROUP worthless if you already run DBCC CHECKDB on all databases?
DBCC CHECKDB makes many other integrity checks redundant, but I can't see anything in the documentation saying if it makes DBCC CHECKFILEGROUP redundant. Is DBCC CHECKFILEGROUP worthless if you ...
- 545
-2
votes
1
answer
36
views
How to modify filepath of a database file that is inside a file group [duplicate]
How do you modify filepath of a database file that is inside a filegroup?
Just the normal and direct way?
Alter database []
Modify file (name='', newfilepath='')
Or
Alter database []
Modify filegroup ...
1
vote
1
answer
60
views
What is an example to understand that having multiple data files helps with latch pages in parallel?
You will always benefit from multiple data files, because then SQL
Server is able to latch multiple system pages in parallel in the
Buffer Pool.
Link: https://www.sqlpassion.at/archive/2016/08/29/...
- 3,476
0
votes
2
answers
654
views
Unable to drop file group because it is not empty
I am unable to delete a filegroup. I am getting the standard error: "The filegroup '~~~~' cannot be removed because it is not empty." I have been searching the internet, and still cannot ...
- 332
2
votes
1
answer
743
views
Stats update during Index rebuild
I have a task in hand to move rebuild a big table to move LOB pages to a different filegroup on SQL Server 2017 Enterprise Edition.
I was testing the scripts in a proof-of-concept environment, and I ...
0
votes
1
answer
46
views
Is it advantageous to split parts of large time-based tables and store in separate data files? [closed]
On Microsoft SQL Server, I have large (multi-gigabyte) time-based tables for which I want to periodically age out and archive older data (say at the end of each year drop everything 5 years or older).
...
David Posner
0
votes
1
answer
336
views
How to remove unallocated space after partitioning
I've recently done partitioning on a table (postcode column) and created new filegroups for each postcode.
Now that it is no longer using the PRIMARY filegroup, the file size is still as it is. How do ...
1
vote
0
answers
64
views
What else are there in the file
I am trying to empty a file in order to remove it from database.
First of all, I moved the tables and indexes with creating clustered and nonclustered indexes with DROP_EXISTING = ON in another ...
- 231
0
votes
1
answer
3k
views
How to merge multiple filegroup data files to a single data file?
Have a single 500gb DB with a single file group consisting of 4 data files. This was due to old SAN volume space restrictions that are no longer in play on the new SAN. Would like to consolidate ...
- 1,097
0
votes
1
answer
631
views
Azure SQL - Hyperscale service tier - are table partitions supported
In the Azure SQL DB, running in the Hyperscale service tier, are table level partitions supported? It does not seem to be called out in the known limitations page.
While trying to create a filegroup ...
-1
votes
1
answer
152
views
Attach of renamed files conflicts with original files
I am having difficulties attaching DB in a certain environment while the same scenario works in my dev or other production instances.
SCENARIO
There is a backup of database files (MDF, NDF, LDF, ...
- 945
0
votes
2
answers
135
views
Does changing database growth rate force a new execution plan?
For many years there has been a long running SQL Agent job that has taken nearly two hours to complete. Approximately two weeks ago on a slight whim a decision was made to change the growth rate on ...
1
vote
3
answers
1k
views
Does spreading table data across multiple files (in the filegroup) improve performance?
From the product documentation on filegroups:
For example: Data1.ndf, Data2.ndf, and Data3.ndf, can be created on
three disk drives, respectively, and assigned to the filegroup
fgroup1. A table can ...
- 3,476
2
votes
2
answers
2k
views
SQL Server - Restore only primary Filegroup but bring the database online
I'm trying to find out if it's possible to bring a SQL Server 2016 Enterprise database online by restoring only the primary Filegroup. My scenario is, we have a fairly large OLTP database, of around ...
- 431
2
votes
2
answers
40
views
Indexes all Exist in non Primary Filegroup - Advantages?
I have come across a database where all the indexes are stored on a filegroup that is not the primary filegroup.
The database has 4 files, one of which is in the primary filegroup and the other 3 are ...
- 2,000