All Questions
4 questions
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 ...
- 1
1
vote
2
answers
130
views
Different services using different port pointing to same datadir folder
Let say I have already installed service MySQLa with mysqla.ini (port number=3306) setting and datadir folder in ...\data
Is it possible then, I install another service MySQLb with mysqlb.ini (port ...
0
votes
1
answer
96
views
Are databases only growing in size?
Databases use the file system to store the data.
As far as I know it is not possible to delete a record from a random access file.
So does that mean that when we do a DELETE FROM TABLE the size of the ...
- 771
-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 ...
- 111