Skip to main content

All Questions

Filter by
Sorted by
Tagged with
0 votes
2 answers
46 views

SQL Server: which data file extension should be used when adding a primary file on another drive?

If I have a Windows disk with a capacity of 1T, for example, and the primary datafile (.mdf) for my database reaches the disk's maximum size, I want to add a second datafile to the primary group. As ...
Louis's user avatar
  • 1
-9 votes
2 answers
3k views

Wrong Last Modified Date of .ndf file on SQL Server

I have SQL Server Database and we have many tables. To improve performance, I have created different filegroups with files on different disks just for indexes. I have created new index today in a ...
NA.'s user avatar
  • 111