Question : Context: I am developing an application that requires handling tables that do not necessarily have an uniform structure […]
Tag: datafile
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 […]
Adding specific information to a local file
Question : I have several files on a webserver (not stored in the database). I’d like to store several information […]
Wrong Last Modified Date of .ndf file on SQL Server
Question : I have SQL Server Database and we have many tables. To improve performance, I have created different filegroups […]
mysql_install_db equivalent for MongoDB? Error ‘handle-open: open: Too many open files’
Question : A developer created millions of collections and indexes, this means millions of collection-* and index-* files. I have […]
SQL Server data files and RAID
Question : I have a server with a RAID1 volume (OS + apps) and a RAID10 volume (database). The RAID10 […]
SQL Server split mdf into multiple files
Question : I have a database called example.mdf with a total size of 1GB which suffers from performance issues. I […]
How to delete tablespace and table after delete datafiles?
Question : I deleted datafiles with asmcmd. I need to delete tablespace and tables on this tablespace. I tried: drop […]