Questions tagged [filegroups]
In SQL Server, a filegroup is a logical collection of one or more physical files onto which the database will write.
131 questions
5
votes
0
answers
138
views
Does partitioning allow filegroups with LOB data to be shrunk?
It is extensively documented that shrinking any data files that have LOB pages is awful:
Microsoft says you need to read the whole partition once for every page you want to move.
The well-known ...
- 1,418
4
votes
1
answer
703
views
Why not put every table in its own filegroup?
Piecemeal restores make it easier to recover from whoops deletes. Rather than restoring a whole database, I can restore just the primary and the filegroup of the table with the whoops delete to a new ...
- 1,418
2
votes
1
answer
154
views
What are the downsides of PARTIAL backups?
I have recently found online this amazing article about partial backups by Alexandr Omelchenko
-- this is how he would do a backup:
BACKUP DATABASE your_database TO DISK = 'full.bak'
BACKUP DATABASE ...
- 17.3k
0
votes
2
answers
140
views
how to divide a filetable to several filetable on several disk in sql server?
I have a dms database that use filestream. I want to distribute data to several disk based on year. How can I divide this database to several disk in sql server?
I used Partitioning technique but I ...
- 11
0
votes
1
answer
76
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 ...
- 1,418
-2
votes
1
answer
106
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
169
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,618
0
votes
2
answers
2k
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 ...
- 334
2
votes
1
answer
960
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
79
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
1
vote
0
answers
95
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 ...
- 227
2
votes
1
answer
4k
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,141
0
votes
1
answer
779
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
220
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, ...
- 977
0
votes
2
answers
202
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 ...
