The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

2
votes
1answer
344 views

Is DBCC SHOWFILESTATS an accurate way to see unused space?

We have a few tables each with near 100 million rows of data. A co-worker has these tables setup with partitions based on a date field. Our disk space is starting to run low and knowing that ...
0
votes
1answer
20 views

compare file-based systems and a relational database

I don't know the exact difference of both can you please compare file-based systems and a relational database?
1
vote
1answer
52 views

How to create trigger with NOT FOR REPLICATION

I tried adding "NOT FOR REPLICATION " in many parts in the below code but ended up in the below code. I searched a lot for an example where I can see how its done with a trigger. Can any one show me ...
7
votes
2answers
400 views

MS SQL Server Cumulative Updates - Best Practices

I'm trying to get an idea of what recommended best practices are for the SQL Server Cumulative Updates. Currently, we run on the idea of "do nothing unless an issue fixed by the CU is one we ...
0
votes
0answers
87 views

Why does second instance of database not open?

SQL> startup ORACLE instance started. Total System Global Area 3841982464 bytes Fixed Size 2025392 bytes Variable Size 788531280 bytes Database Buffers ...
2
votes
0answers
75 views

How to make PostgreSQL default_tablespace work properly?

My question is, "Why isn't database 'screwy' created in tablespace 'screwy'? I made the following script, with it's output following, to show the problem I am having : #!/bin/bash # export ...
1
vote
2answers
117 views

MySQL user without SUPER privilege

This may be a simple question and may not be the right place to ask but I couldn't find any useful information from Google. Here is my question. When creating users in mysql using grant all ...
1
vote
1answer
49 views

Turning off auto growth for particular file

We have a primary file group with several files each on different disks. One of the disks is nearing capacity and as such we have had to switch off the auto growth for that file. Is there anything I ...
1
vote
1answer
117 views

Way to run SQLCMD without storing password in text format

Is there a way to run sqlcmd from a batch file where I don't want to store the password in plain text format. I have done some research and found the system variables method(store password in system ...
-1
votes
1answer
8k views

IO Error: The Network Adapter could not establish the connection - with Oracle 11gR2. Connecting with SQL developer

I have installed Oracle 11g ON a RedHat6 linux instance, by following all the steps mentioned in "http://technologylair.net/2013/08/oracle-11g-installation-linux/#comment-50" I am trying to connect to ...
0
votes
1answer
51 views

PHP SQLite Admin is running on PHP 5.4

I tried phpsqliteadmin But it doesn't seem to work anymore on PHP 5.4. There are several alternatives, but none of them seems to be "The One" that is maintained and widely used. Is there a standard ...
5
votes
1answer
97 views

SQL Server 2012 Unable to Utilize Defined Amount of Locks

So I've been beating my head against the wall for two days about this and I can't find a solution. I'm running a script to stage a large amount of data. This script requires roughly 35 million locks ...
0
votes
0answers
53 views

How to skip already created table while importing dump file in MySql

Is there any way to skip already created tables while importing ? I am trying to import 2GB of database using command prompt but the operation is aborted by mistake. Now if i will do the import again ...
1
vote
2answers
88 views

Limiting read access in postgres to few rows

We have a requirement where we want to limit the maximum no. of rows that a select query can return when its done using a particular login. So basically we would like to append a limit clause to any ...
0
votes
0answers
122 views

Archive Logs not applied on Primary Database

I have a oracle database and some archive logs in the primary database have not been applied. When I run SELECT THREAD#, SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG order by SEQUENCE# I get the following ...
0
votes
3answers
184 views

SQL Server: unable to copy database

I'm trying to create a dev database so I don't create triggers and such on the production database. I use the right click -> Taks -> Copy, followed the wizard and the process starts. After maybe a ...
1
vote
0answers
22 views

What is the best type of database for numerous multi-threaded access? [closed]

I am developing a simulation and have limited experience working with databases (very limited SQLite3 exposure). Here is my task: Server that stores a potentially large database (no size requirement ...
0
votes
1answer
186 views

MySQL slave database wont start

I have a MySQL master slave configuration and the slave is not working anymore. When trying to stop and start again the slave db, I am getting this error: 140530 14:21:23 [Warning] Slave I/O: ...
0
votes
0answers
51 views

Oracle 9i Low performance on Windows Server Enterprise 2003

I'm facing some problems with performance with my Oracle database running on a virtual machine with Microsoft Windows Server Enterprise 2003 with 8GB RAM. It works pretty well after the database is ...
1
vote
1answer
77 views

Way to ensure just one connection to a DB2 database

Let's suppose a database with a bad security design, say everyone access to the database with a user with DBADM or SYSADM authority, and also, there could be only username for everyone (i.e. ...
1
vote
3answers
118 views

Mysql to Oracle communication

I have a website running with php and mysql on Centos(Amazon instance). The newly brought ERP(to be integrated with existing system) uses Oracle as db(located on a separate Windows Server). The orders ...
0
votes
0answers
756 views

Uninstalling Oracle Database Products: Which & How to?

Long time reader, first time poster. For our client's project we are using Oracle 11g. It's a simple C# web application so we are using Oracle's most basic components. Now my project team has been ...
3
votes
1answer
42 views

“zip” a mySQL (phpMyAdmin) database [duplicate]

I've created a large database on my local WAMP webserver. I would like to send that database with all tables and table data to another computer. Is this possible? mySQL ver: 5.5.15 PHP ver: ...
1
vote
1answer
77 views

What is the advantages of using auto_increment in database as primary key over set of attributes?

I have table as CREATE TABLE circle ( circle_id int(11) auto_increment primary key not null, user_id int (11) not null, title varchar(255) collate utf8_general_ci not null ); CREATE ...
0
votes
1answer
88 views

What is the strategy of query evaluation in DBMS when Limit is used in query?

I have following tables in database post(post_id , user_id , post_text , parsed_text) ; Comment(comment_id , post_id , user_id , comment_text) ; friend(id , user_id , friend_id ) ; group (id , ...
1
vote
2answers
708 views

What is meant by DDBB?

Today we got a term DDBB. I am not sure whether it refer normal database or database driver in certain programming language. Google search did not help me much in this. And I am sure it is not 'Dirty ...
2
votes
1answer
44 views

How can I enable logging for a single function in PostgreSQL?

I want to log the whole function runtime for a single particular function in PostgreSQL? Is this possible? The value of log_min_duration_statement = 3000 in postgresql.conf and I've tried to do: ...
1
vote
1answer
43 views

Shared emails in a database [closed]

We lost our database administrator over a year ago - and even then she was promoted into the job internally and sort of learned on the job. Basically I say this to establish that strong data standards ...
1
vote
1answer
108 views

Maintenance plan using external tool to execute query and stored procedures giving off no results

My situation is as follows: I am using a third party tool (VisualCron) to run stored procedures and sql queries on several database servers. The stored procedures are from http://ola.hallengren.com/ ...
2
votes
0answers
206 views

Recover innodb database from ibdata1 and *.frm files only

I have a problem on my server. I had a hard disk error on my server, and I restarted it. After that, I started wamp server software, but mysql services were not started. I checked all mysql data, ...
1
vote
1answer
962 views

First query running in PL/SQL Developer results the error

When I run first query in PL/SQL Developer I got the error: Dynamic Performance Tables not accessible, Automatic Statistics disabled for this session You can disable statistics in the preference ...
5
votes
2answers
128 views

Is it somehow possible to predict / foresee when SQL Server will trigger auto-growth?

I found numerous questions / answers about SQL-Server auto-growth - almost all indicating that one should try to avoid auto-growth if possible. However auto-growth is available with MS SQL Server and ...
1
vote
1answer
190 views

SQL Server agent job scripts

Being a newbie to database migration, can I script all the database jobs one by one and run them against a new server to create these jobs? If not, why do we use these SQL job scripts? Thanks in ...
2
votes
3answers
939 views

Oracle 12c in-memory option

I've been told that there's an oracle in-memory option for 12c and that it uses columnar compression to get some great query speeds. I'd like to leverage it for some business intelligence stuff. I've ...
2
votes
1answer
69 views

What are these files in MongoDB?

I was looking into my server and I found this: [root@host ~]# cd /var/lib/mongo/journal/ [root@host journal]# ls -lh total 3.1G -rw-------. 1 mongod mongod 1.0G Apr 7 01:18 j._0 -rw-------. 1 mongod ...
0
votes
0answers
41 views

I need a way to implement an incremental Backup/Recovery on mysql client

I need to be able to do a point-time recovery in mysql client from the mysql server. For example I need to Download only the information that have change since last backup. I can do that using log,but ...
2
votes
0answers
100 views

Should I use SQL Azure to store product descriptions and links to images in Azure Blob

For an html/Css/JQuery public Azure website to be coded using Zurb Foundation html5 responsive framework, I'd like to use SQL Azure (web edition) to store product descriptions and links to images that ...
2
votes
1answer
99 views

SQL Server - Data and Log Separation

We have a SQL Server 2008 R2 which has, among others, a 12K RPM HDD and a 7.2K RPM HDD. The original intention was to store the data files on the 12K drive and the log files on the 7.2K drive, as is ...
0
votes
1answer
148 views

Update table from calculated temporary table

I have two tables, one containing a set of user ID's, vote direction (-1 or 1) and ID of the object they voted on (casted votes table). In the other table, the object id, upvotes, downvotes and ...
2
votes
1answer
93 views

Recovering a partial PostgreSQL archive

I have $PGDATA/base but nothing else. It was taken from an installation after the postgreSQL service was shutdown, so is clean. Is there any way to recreate the other elements in $PGDATA that allow ...
3
votes
3answers
1k views

How can I enter Mongo as a superuser or reset users?

I'm was playing around with permissions and locked myself out of Mongo database. I'm pretty sure I did this by trying to explicitly add access to a database but instead I overwrote only allowing ...
0
votes
1answer
137 views

Moving the IBM Informix IFMXDATA directory to another machine

I'm a total newbie when it comes to Informix DBs, and I'm stuck with what looks like files that contain an Informix database. I'd like to know if it's possible to add or import these files into an ...
1
vote
0answers
4k views

Importing a different character set export dump into another DB instance

I am trying to import a given dump file using oracle imp utility. However; I am facing the following issues. C:\Users\AD>imp DB_USER/*****@dev1 file=C:\test\db42312.dmp log=C:\test\import2.log ...
3
votes
2answers
181 views

SQL Server 2012 Compatibility

I'm converting some stuff over to be compatible with SQL Server 2012 and had a couple of questions. I'm taking out all of the sp_dboption commands and making them ALTER commands instead, but there ...
1
vote
1answer
318 views

Remove single quotes from db2 column name

I have following query which i am trying to execute against db2 database server SELECT REPLACE('\'abc\'','\'','') FROM TN_DAY_PROCESS I am expecting the output like abc without single quotes from ...
0
votes
1answer
86 views

Does redundancy exists in this table?

I'm studying a DB course and I found this table: In this exercise, the objective is to determine whether the table has redundancy or not. According to the definition of redundancy Data ...
0
votes
3answers
144 views

Large RAM use after import database - ubuntu server

My new VPS has 4GB of RAM. Before importing database system use about 1.2 GB of RAM. When I import into the database, using 250 MB SQL file, 25000 tables use of RAM goes to 97%, htop showing 3302 mb ...
0
votes
1answer
247 views

Pentaho 4.4 Database connectivity issue

I am getting the following in one of my transformations. I am trying to extract data from SQL server and pushing to mongodb. 2014/04/03 13:11:10 - EMPLOYEE TABLE Input.0 - linenr 700000 2014/04/03 ...
0
votes
1answer
633 views

Oracle Enterprise Manager - Where do I find the error logs?

I'm not familiar with oracle management. The problem is when I try to connect to the enterprise manager through the Web browser I get this error: In english: "Internal Error has occurred. Check ...
0
votes
0answers
53 views

Create replication sql server for DWH [closed]

I have a DWH and I need to make an update once a day from STG Database to DWH I need use replication in SQL SERVER, How I do this?