The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

-1
votes
0answers
30 views

SQL WHERE statements by Row Number

I have a Data Loader that will only let me upsert 1000 at a time. I have a DBF File that has about 5000+ records. I have a section where I can make WHERE statements for that particular upsert. ...
2
votes
2answers
340 views

DB2 db2fm proccess [closed]

Server is been up for 365 days, however i got some weird repeated procceses. Are these normal? ps -fea | grep db2fm db2inst1 643284 229516 29 May 25 - 212564:06 /home/db2inst1/sqllib/bin/...
0
votes
1answer
23 views

Overwrote database with old mysql dump. How can I restore it with a more recent backup

Have a server with multiple databases. Imported wrong .sql from over the top of existing database. I Have a rsync copy of the up to date files for that database. What do I need to do to just ...
1
vote
2answers
32 views

Routinely deleting aged postgresql rows via cron

I have a Django website with a postgresql 9.3.10 backend. The website contains dynamic user-generated content (think of it as a form of 9gag). There are some tables from which I routinely delete aged ...
1
vote
1answer
48 views

How to restore MySQL databases from database files?

Our MySQL on Ubuntu 15.04 stopped working after we moved the computer to a new location and kept giving the missing socket file error. We couldn't really fix it after trying sudo apt-get install -f ...
1
vote
1answer
37 views

Simple Database Design - Many to many? - First database (newbie)

This is my first database I am designing. However I am getting confused on the many to many relationships. I have a products table, each product can have inventories in many different warehouses. So ...
2
votes
1answer
7k views

Truncating Table Partitions Containing Data and Global Indexes

I have to truncate a partition (392,000 records) of a table with 20.000.000 records. At the moment, I'm making a truncate table and rebuilding indexes. But the table has 37 indexes and it takes 20 ...
0
votes
1answer
48 views

how to update information_schema.tables in mysql [duplicate]

i have a table A and i want to update the creation time of this table. I understand i cant simple update ( using update query) as it is not any table. Is there any way i can update it. for example ...
2
votes
1answer
59 views

What is the cardinality of entity relationship between Employee and Department?

Recently, a friend of mine asked me this question about the cardinality between a Department and Employee entities, I replied many to many, then he, my friend, showed me drawings from the internet ...
0
votes
0answers
64 views

What are PDE files and how can I use them?

I've got a legacy DB which was given to me as a collection of PDE files. I've googled around and didn't come up with any useful information. Saw this question: Import .pde file on PL/SQL Developer .....
0
votes
0answers
33 views

SQL Server Memory Configuration [duplicate]

My Server has Total RAM 200GB. I have set 80% of total RAM for SQL Server as it needs more memory. Just want to know if there is any fixed number or method to finalise amount of memory to be set for ...
0
votes
0answers
38 views

Temp DB configuration

My TempDB disk size is 100GB. Out of that I have made below split: 80GB/8 = 8 Data files. 15GB for Log file. Remaining 5GB I have left for autogrowth for last eight datafile and log file(...
1
vote
0answers
25 views

Check Postgres Listener is up/down?

I am using PostgreSQL LISTEN/NOTIFY functionality in Java. So I have made a ListenerBean which is run at Application startup. LISTENER class in java: @Singleton @Startup ...
1
vote
1answer
41 views

any better way for data archiving?

I'm in one security company and our history data grows fast, causing data archiving sqls run slower and slower. Say, for the sake of data real-time need, the scripts must run in a high frequency for ...
1
vote
0answers
24 views

LISTEN/NOTIFY pgconnection goes down java?

I am using PostgreSQL DB and applying it's LISTEN/NOTIFY functionality. So my listener is at my AS (Application Server) and I have triggers configured on my DB such that when CRUD operations are ...
1
vote
1answer
24 views

Managing SQL Server logins and database users

I am getting a little further into the database administration side of things and starting to set up security access to SQL server databases for users. I have a question about server logins and ...
1
vote
2answers
59 views

Log in as another SQL Server user via SSMS to check their permissions?

I am getting a little further into the database administration side of things and starting to set up security access to SQL server databases for users. I have a question: Once I have given a set of ...
0
votes
0answers
17 views

Mix mode auth password,is it sa password?

During SQL Server 2014 Installation,I have set up Mixed Mode Authentication and given a password for it.My question is when I set Mix mode,did I set up password for SA login.So if want to use SQL ...
0
votes
0answers
34 views

Does having a .ldf for a index file cause issues?

Interesting find today, I have a file group that is used for indexing. It has one file that has a .ldf extension, which as you know for SQL Server, is the extension for the transaction log files. My ...
0
votes
0answers
228 views

Merging time series in influxdb 0.9.x

I have a system which demands monitoring its metrics. In order to do that I use grafana + influxdb. The version of influxdb I currently use is 0.9.x. I want to be able to calculate some statistics. ...
1
vote
1answer
24 views

Can I specify the default backup location for non-automatic backups?

I noticed that when the BACKUP DATABASE command is issued without the TO clause the backup file is stored to the working directory where the command is issued. I'm wondering if it's possible to ...
-1
votes
1answer
76 views

What are static tables & dynamic tables?

I heard the term "static table" when I'am learning about dirty reads in database. Can anyone explain what is a static table and what is a dynamic table ? Thanks in advance.
1
vote
0answers
41 views

Where can I find information on what resources are consumed when connections are established with MSSQL 2012?

I'm trying to troubleshoot the following intermittent sql connection error: "DESCRIPTION: SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection. ...
1
vote
0answers
24 views

McAfee antivirus and File stream SQL Server 2008 R2 Issue

I am facing file stream issues in SQL Server 2008 R2 and I am not able to correlate things and how to fix them. Below are the event logs. Please let me know if they both the errors (One is Mccafee ...
3
votes
1answer
2k views

How to create Postgres DB with case insensitive collation

I am using the postgres version 9.4.1 64-bit on windows 7 64-bit. I need to create DB with the setting "case sensitive = OFF" but couldn't make this work. I refereed already many question on SO and ...
0
votes
0answers
26 views

Replicate SCCM2012 DB to secondary read only server

We have a SCCM2012 DB that we're looking to replicate out to a SQL2012 or above server. The reason for the replication is for a new ITSM system to use ODBC to extract information about devices without ...
0
votes
0answers
33 views

TCP Provider Issue

Error : TCP Provider: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to ...
1
vote
1answer
63 views

MySQL57 is using 25% CPU and 10% Memory on Desktop

I do a simple left join query on two fairly large table using MySQL57. It takes a long time. I check my desktop's CPU and memory usage for MySQL. It only uses 25% CPU and 10% Memory on my Desktop of ...
0
votes
1answer
32 views

Accessing a Linked server [closed]

I am fairly new to the whole DBA scene. With that said, i was able to get an ODBC connection established within Microsoft SQL Server 2012 to be able to access a database for a library. Now what I am ...
1
vote
1answer
29 views

password confusion in postgres sql

I have logged into postgresql server using sudo -u postgres psql Then I also created a database from within /usr/local/bin directory using the command. createdb -h localhost -p 5432 -U postgres ...
1
vote
1answer
38 views

Order by varchar mysql

Is there anyother alternative for order by varchar clause? At worst case consider I want to order by varchar column that is not indexed. When I tested a query with loads of data it took many times to ...
3
votes
1answer
50 views

help in the initial configuration of postgreSQL9.6

I recently installed postgreSQL9.6 version on windows 7 64 bit machine. During the installation process, I was asked to key in the super user password and the locale of the database (I chose default ...
0
votes
0answers
41 views

Install Oracle Instant Client components from Custom option

Installing the Oracle DataBase Instant Client 12c, 4 options are displayed: Instant Client - This installation type installs only the shared libraries required by Oracle Call Interface applications ...
0
votes
0answers
20 views

Innodb Change Buffer merge

I have been testing the performance of my innodb mysql. I ran a script which inserts and selects one after the other for 100000 times. So according to the change buffer concept, the inserted ...
2
votes
0answers
15 views

What is the best way to keep track of 1000 RDS hosted databases?

I want to know what is 'best-practices' for managing an extreme number of RDS instances. I have no problem managing five. But managing dozens or hundreds, that's another task. I'm thinking use a ...
0
votes
1answer
34 views

Mysql repetition of column in Criteria

What happens when I repeat the same column in the criteria part but with different values . For example col1 ='val1' or col1 = 'val2' or col1 = 'val3' . Assume col1 is not indexed. Will mysql ...
0
votes
2answers
34 views

How to figure out who is the user of the DATABASE [closed]

how to find out whether the database is still active or not. I'm trying to delete old inactive databases.
0
votes
0answers
8 views

Generating the sequence number

Would you please help me how to generate the sequence number (DOC_NO) so that every time MO_ID value changes to a new number, the DOC_NO column will increase by 1. THANKS MO_ID DOC_NO MNZ456 1 ...
3
votes
2answers
159 views

Best fill factor for GUID clustering key

We have a database that uses GUIDs for most of their columns in a data (non sequential). Does anyone have any best recommendations for fill factors on a GUID database in an hgih insert/update database?...
0
votes
1answer
32 views

Log Backup in AlwaysOn

In our current process, log backup is done by log shipping backup job. Is there any need to configure backup job for transaction log in next AlwaysOn environment? If we must configure backup, we ...
2
votes
2answers
51 views

Postgres - Regroup rows with at least one common attribute

I have the following table : Letter | Figure -------|------- A | 1 B | 1 B | 2 C | 2 C | 3 D | 3 E | 4 I would like to group rows that share ...
0
votes
1answer
46 views

What happens when the buffer pool size is insufficient in mysql

Let us assume I run a query for a table whose size is very huge. My buffer pool size is as low as possible. What happens now? whether I will get an error regarding the insufficient space in buffer ...
1
vote
0answers
31 views

Re integrate MSSQL 2008 to new Active Directory

I have a server which was joined to an AD Domain, then installed with MSSQL Server 2008 R2 and System Center Operations Manager 2012's Reporting Server on it. The same server had the Active Directory ...
0
votes
1answer
17 views

shipping data without impacting performance

I am new to DBA - actually deputising for a colleague on maternity, Im a sql developer. My company, an on-line retailing coy wants to move copies of our databases from our prod server to a back up ...
0
votes
1answer
54 views

Oracle 12c : Unable to install sample schemata on Windows 10

I've gone through lots of trial and errors in installing the sample schemata for Oracle 12c and still can't get it right. I have a pluggable database named PDB01. I also have an instantclient ...
1
vote
1answer
23 views

Is there a way to associate a description with database snapshot?

Is there a way to associate a description with database snapshot? I usually name snapshots using original database name and timestamp: DBName-05-27-2016_1018 I would like to be able to associate a ...
0
votes
0answers
33 views

Managing large database tables, large tables VS seperate databases

In my project I have a system where users sign up and perform daily tasks. Note that I am not a database expert, none the less I am trying to solve a potential issue that may arise. A problem has a ...
1
vote
2answers
73 views

Sanity Test on Oracle Upgrade Database

My oracle sever has been upgraded from Oracle 10g to 12c. DBA has created a box for that now my question is how developers will perform testing on that.. Can anyone provide me the sanity or unit ...
1
vote
3answers
88 views

DBCC CHECKDB consistency-based I/O error

Running: DBCC CHECKDB(DatabaseName) with NO_INFOMSGS gives me the following error: Msg 824, Level 24, State 2, Line 1 SQL Server detected a logical consistency-based I/O error: ...
-1
votes
2answers
143 views

database Compatibility 90 to 100 changing causes any problem

We are planning to change Compatibility level of databases from 90 to 100. Would this cause any impact on application side? If yes then please guide me, what steps or measures we need to look upon ...