Question : Long story short we have a server with two Oracle instances running on it: ora1 and ora2. Somebody […]
Tag: datafile
Two SQL Server databases share the same MDF and LDF files but have different data [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Where/how does innodb store tables in files?
Question : I read somewhere that InnoDB can store all the tables in a single file or in separate files. […]
How to Move TempDB Files to a Different Drive or Folder? [duplicate]
Question : This question already has answers here: Safely moving and creating new tempdb files (3 answers) Closed 4 years […]
How can I set block size on Oracle 11 when creating a database instance
Question : Is there any way to configure Oracle 11g’s default block size on installation? I have tried Oracle 11g […]
What’s better/faster? MySql or FileSystem?
Question : Let’s imagine a web site that is a directory of people. For each person there may be a […]
What is a good practice for storing unstructured tables as a field in mongodb
Question : Context: I am developing an application that requires handling tables that do not necessarily have an uniform structure […]
Removing secondary data files. DBCC SHRINKFILE: Page could not be moved because it is a work table page
Question : I have too many secondary data files (.ndf) created for tempdb. To remove the excess files, I need […]
Why is MySQL database data-files deployed under /var/lib/mysql?
Question : I was wondering why do we deploy data files under /var/lib/mysql/. Is there a logical reason for that, […]
DBCC ShrinkFile EmptyFile fails due to system table SYSFILES1
Question : In following a recommendation from our new storage vendor, I’m trying to split up some large & busy […]