The datafile tag has no wiki summary.
3
votes
2answers
86 views
Disk space full but logical space available in database
We have a fairly big MS SQL 2008R2 database that resides on a SSD drive. The drive itself only has ~110Gb of space, and the database files are the only files on the drive.
The database is in "Simple" ...
2
votes
6answers
373 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 ...
3
votes
2answers
262 views
Shrinking the SYSTEM tablespace in Oracle
Our SYSTEM tablespace grew out of control because of the SYS.AUD$ table.
We have truncated SYS.AUD$ but the datafile is still very big (~30G).
Resize doesn't work because the file contains used data ...
0
votes
1answer
42 views
SQL Server database files on different disk as is OS installed
My very short overview
SQL Server databases are installed as virtual machines on VMWare, there are plugged a few disk areas with the same (or very similair) parameters
versions are SQL Server ...
0
votes
4answers
612 views
What's better/faster? MySql or FileSystem?
Let's imagine a web site that is a directory of people. For each person there may be a profile photo and a biography.
I'll admit my SQL queries could be better but in general what would be faster and ...
2
votes
1answer
85 views
Identify File Growth Events
I'm discovering a number of DBs in my portfolio that have been created with default autogrow settings (either 1 MB or 10% increments) that have expanded for an extended period of time. If I wanted to ...
0
votes
1answer
314 views
Save output from multiple SQL SELECT commands to a file
Within a Postgres function I would like to run a number of SQL SELECT commands and append the output to the same variable. After all the SELECT commands have run this output should be written to a ...
2
votes
1answer
188 views
Restore InnoDB tables / database using only data files
I have MySQL Server 5.1.51 installed on Windows Server 2003 as Operating System and using InnoDB as database engine.
I have run DROP DATABASE dbName statement by mistake. I have no backup of that ...
2
votes
1answer
59 views
Adding specific information to a local file
I have several files on a webserver (not stored in the database). I'd like to store several information to this specific file. The user should be able to post comments about this file.
My question ...
4
votes
4answers
542 views
Do I really need to keep .LDF files?
Each month we make an end of month snapshot of our production databse. These month end snapshots are strictly for reporting purposes, there are no inserts, updates or deletes ever done on them. Each ...
1
vote
1answer
261 views
Are multiple dbf files better than one?
Is it better to distribute a large database over several dbf files than over a single one?
1
vote
1answer
476 views
How many files should I create for one filegroup and 9 weekly partitions?
I have 9 weekly partitions on one filegroup. How many files do I need to create?
There are 3 tables containing 46 million, 16 million and 10 million rows.
1
vote
1answer
99 views
file not found - how to remove its configuration?
I run oracle 10.2.0.5.
I have the following:
SQL> select file#, status, error, recover, tablespace_name, name
2 from v$datafile_header
3 where recover='YES'
4 or (RECOVER IS NULL AND ...
