All Questions
3 questions
5
votes
1
answer
989
views
Find what data is placed in a datafile
I have a database with 5 .ndf (secondary) datafiles on SQL Server 2008 R2. (Each of these datafiles is assigned to a separate filegroup.) I want to know what data is there in those files. Is it ...
- 1,550
4
votes
6
answers
21k
views
SQL Server split mdf into multiple files
I have a database called example.mdf with a total size of 1GB which suffers from performance issues. I checked the allocated hardware and it is higher than required, I double checked the design and ...
Mohamed Sawaf
3
votes
1
answer
2k
views
Difference in space used
When reviewing the space used by datafiles in SQL Server, there is a large difference betweens what SQL reports and Windows.
How can this be explained?
- 192