The tag has no usage guidance.

learn more… | top users | synonyms

-8
votes
3answers
2k views

Wrong Last Modified Date of .ndf file on SQL Server [closed]

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 ...
4
votes
2answers
3k views

Splitting a large SQL Server MDF file

I have a large (1.2 terabyte) SQL Server database that I need to migrate to a new server. Most of the database lives on a single, 1.25 TB data file, and a little bit sits on a much-more-manageable 550 ...
0
votes
2answers
503 views

MySQL database datafiles in windows SystemData directory

When I create a database and some tables in MySQL Server, it makes some data files in Windows SystemData directory in C:\ProgramData\MySQL\MySQL Server 5.5\data\mydb\. Each table has three files with ...
2
votes
2answers
3k views

Oracle datafile extension .dat or .dbf

I have seen these 2 extensions used for datafiles, .dat and .dbf while creating and/or altering a tablespace. I'm not sure what the difference between the 2 extensions is, or if .dat is incorrect. ...
3
votes
2answers
1k views

Autogrow. Primary vs additional data files

My databases all use autogrow, which grows the primary MDF file on a percentage. But one of the databases, from a third party application grows by adding additional .NDF files. Where is this option ...
3
votes
2answers
7k 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" ...
1
vote
1answer
187 views

Should database files be on different disk(s) than OS?

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 2005/...
5
votes
2answers
2k views

Multiple SQL Server data files on same SAN disk

I'm currently in the process of creating a new database, and have previously only ever used a single data file and a single log file. I've done some research online regarding the benefits of multiple ...
4
votes
2answers
6k 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 ...
3
votes
6answers
11k 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 ...
6
votes
1answer
8k 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
6k 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
307 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
69 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
15k 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
1k 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
708 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.
6
votes
4answers
4k 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
487 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 ...
23
votes
5answers
59k views

How to insert (file) data into a PostgreSQL bytea column?

This question is not about bytea v. oid v. blobs v. large objects, etc. I have a table containing a primary key integer field and a bytea field. I'd like to enter data into the bytea field. This ...