0
votes
0answers
2 views

Connec to PgAdmin III to localhost

I just want to login for first time, from PgAdmin III to localhost # TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections ...
1
vote
1answer
115 views

How to configure connection accessing Sybase Anywhere from Sybase IQ via ODBC on Linux

I'm trying to access an ASA16 server from IQ16 via ODBC driver. Both servers are installed on the same Linux box. I've installed unixodbc-bin and added a file .odbc.init into home of user running ...
0
votes
0answers
3 views

When to rebuild and when to reorganize indexes

I have been trying to gather information about rebuilding and reorganizing indexes. From stackoverflow page (How Often should the indexes be re-build in sql-server DB?) i got this query : SELECT ...
0
votes
1answer
661 views

MySQL PDO Cannot assign requested address

Can someone help me with this error? [08-Apr-2013 17:44:08 Europe/Berlin] PHP Warning: PDO::__construct(): [2002] Cannot assign requested address (trying to connect via tcp://****:3306) in ...
0
votes
1answer
6 views

Which file in “MySQL-5.0.27-win32” folder do i need to backup?

Ok, I am using a pretty old MYSQL "mysql-5.0.27-win32" and the file and the structure maybe different from the latest Mysql (mysql 7). Here is the current structure of of mysql-5.0.27-win32: In ...
0
votes
1answer
10 views

Which files in the “MySQL-5.0.27-win32” folder do i need to backup?

Ok, I am using a pretty old MYSQL "mysql-5.0.27-win32" and the file and the structure maybe different from the latest Mysql (mysql 7). Here is the current structure of of mysql-5.0.27-win32: In ...
0
votes
1answer
47 views

How to perform same DML statements on two different servers (Oracle and SQL-Server) simultaneously

I have two servers, Oracle and SQL-Server. I have same database on both the servers. I want to perform DML (insert,update,delete). How can I perform same DML statements on both the servers ...
0
votes
0answers
4 views

How to join 3 tables together given 2 many-to-many relationships tables in between?

I have 3 main tables: Person, Publication and Conference and 2 many-to-many link tables in between: person_publication and person_conference I want to join all 3 main tables together (showing me all ...
0
votes
1answer
9 views

Does leaving a connection open for a matter of seconds cause deadlocks?

I have been testing a system application and have noticed that it is slow when it connects to the database overseas. This is to be expected to some extent, but there is a big difference with the ...
0
votes
3answers
926 views

Freeware GUI tool for DB2 , usable in Ubuntu Linux

Are there any freeware user interface tools for DB2 to be used in Linux (Ubuntu 11.04)? RazorSQL is pretty good, but it's not freeware.
0
votes
2answers
3k views

MySQL shutdown unexpectedly

2013-09-09 10:21:44 5776 [Note] Plugin 'FEDERATED' is disabled. 2013-09-09 10:21:44 1624 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future ...
5
votes
2answers
451 views

“Arithmetic overflow” when initializing SQL Server 2012 replication from backup

I'm initializing SQL Server replication from a backup, by following instructions from here: http://www.mssqltips.com/sqlservertip/2386/initialize-sql-server-replication-using-a-database-backup/ ...
0
votes
0answers
12 views

What's the optimum hardware configuration for a database?(SQL Server)

Database circumstances are different from place to place, but there are a few theoretical areas which should prove true for all circumstances. I think it would be great if it is summed up in one ...
0
votes
0answers
4 views

SQL or NoSQL for structured clinical data

I'm designing a database for a primary health center, the idea We basically have a Patient with many Encounters, also the Encounters have to be entered from different Users (Health Professionals). ...
2
votes
2answers
875 views

12c Grid Agent installation issues - Shell path is incorrect or not defined

I am installing 12c Grid Control agent on my server via Enterprise manager. The targer server is a UNIX server with AIX OS on it. I add target host manually, enter authentication information, host ...
0
votes
1answer
11 views

how to change mysql table auto_increment primary key

Now i have a table with Auto_increment id as Pri key, and exchange_id as key, How could I change the primary key to field [ticker]..?
0
votes
1answer
546 views

How to create Oracle RAC database using dbca silent mode with different db_name and db_unique_name

I have a requirement to use dbca (version 11.2.0.3) silent mode to create a RAC database on a 2-node RAC and the db_name and db_unique_name must be different, I tried following dbca command ...
1
vote
1answer
25 views

Optimizing large MySQL SELECT WHERE IN clauses

How can the following SELECT WHERE IN case be optimized? I have a table with over 100 million rows with only 3 columns. The primary key (col1) is a 127 varchar. I am performing a SELECT col1 WHERE ...
0
votes
1answer
1k views

Error on changing ownership of database from Files Page in database properties dialog box

I've restored a database and created a new user(same user from which I've logged in) as db_owner. Now when I wanted to see database diagram got an error Database Diagram support objects cannot be ...
3
votes
2answers
56 views

Are ORDER BY clause & ROW_NUMBER duplicating functionality when I need top n queries

I have a table that tracks violations for a student. I want to count the number of violations and select top 2 violators from each class. The query would look like this SELECT * FROM ( SELECT ...
0
votes
1answer
137 views

exception: hosts cannot switch between localhost and hostname

I created a replication set. I added localhost in the set in the beginning, but when I try to edit the member with the actual hostname. I get error "exception: hosts cannot switch between localhost ...
0
votes
1answer
86 views

Export, based on query, into INSERT text file

I need to export some data into a file. The data are selected with a query that will often be made of multiple joins. I want the import operation to be as easy as possible. I was thinking of building ...
0
votes
2answers
27 views

Mysql LEFT JOINing same table twice

mysql> SELECT * FROM customers; +----+------+ | id | name | +----+------+ | 1 | Matt | | 3 | John | +----+------+ mysql> SELECT * FROM purchases; +----------+------+-------+ | owner_id | type ...
0
votes
1answer
1k views

What is the actual difference between innodb_autoinc_lock_mode 0,1,2

I would like to understand the differences between innodb_autoinc_lock_mode options 0,1 and 2 when parallel load data infiles are given. I see in "0" option, it locks the entire table and does the ...
0
votes
0answers
8 views

How to configure phpgdadmin?

I have some problems configuring phppgadmin. Initially I loaded phppgadmin over EnterpriseDB stackbuilder and it worked fine. After upgrading my OSX from OS 10.6.8 to 10.8.5 phppgadmin didnt respond. ...
0
votes
0answers
4 views

How to do unattended install of SQL Server Express 2012 from the Enterprise media?

So I have a requirement to install SQL 2012 Express on some machines, and SQL Enterprise on some others, and I'm attempting to avoid using separate packages to do so. It's pretty simple to install ...
0
votes
0answers
16 views

How to configure pgmodeler?

I am having some troubles configuring pgmodeler, particularly the Connections. I put Connection DB: postgres Host/Port localhost 5432 User postgres ...
0
votes
1answer
39 views

Why does 'plpgsql' not appear in the pg_extension table?

I have two Postgres 9.1 installations. One works properly, the other does not. On the working installation: dc=# select * from pg_extension; extname | extowner | extnamespace | extrelocatable | ...
0
votes
1answer
18 views

Large NOT IN Statement vs Creating/Populating Temp Table

I have a large daily data feed which can contain up to around 5,000 ID's. I need to delete all pre-existing records in the DB that are not referenced in the new feed. Should I create a temporary table ...
0
votes
1answer
15 views

table exists on 'show tables' - can't query

Anybody know why this his happening? mysql> show tables; +-------------------+ | Tables_in_photos | +-------------------+ | captions_images | | image_meta | | mentions_images | ...
0
votes
1answer
10 views

Getting error while running dbca command as oracle user on linux, please help me on this

could someone please help me on the below error to get ride of it: [oracle@localhost ~]$ dbca UnsatisfiedLinkError exception loading native library: njni11 java.lang.UnsatisfiedLinkError: ...
2
votes
0answers
25 views

Adding warning with sp_add_alert doesn't work with “Greater Than” and SQL Server 2014

We upgraded our SQL Server from 2008 R2 to 2014. I want to add a custom warning. USE [msdb] GO EXEC msdb.dbo.sp_add_alert @name = N'MAN more than 1000', @enabled = 1, ...
0
votes
0answers
41 views

slow writes on percona server only when replication is running

Hi I am trying to migrate to percona server from mysql 5.6 on windows. In my development machine for percona is running of centos 6.5 which is installed on vmware 5.5 sphere. Our business ...
1
vote
1answer
126 views

Innodb buffer pool indexes versus data usage

The server has 128GB of RAM. The innodb_buffer_pool_size is set to 106GB. mysql> show global variables like 'innodb_buffer_pool_size'; +-------------------------+--------------+ | Variable_name ...
0
votes
1answer
17 views

MySQL Database Memory Consumption

i am newbie in mysql, just want to ask if what is the right formula in computing memory allocation for mysql, and how to check/query mysql memory consumption or we say where does memory consume by ...
0
votes
0answers
12 views

SQL Server 2012 Slow Remote Connection and SSRS Manager

I am running SQL Server 2012. Everything was running fine until a couple days ago. The SSRS Web Manager Interface is extremely slow even after initial load, even just navigating folders can take ...
0
votes
0answers
3 views

How import cvs/excel data into myphp table with existing data, without overriding the existing data?

My first question. So thank you in advance for your answer. I am looking for any easy way, without too much coding, to import cvs/excel data into myphp table with existing data, without overriding the ...
2
votes
3answers
56 views

Entity Relationship Model - double one to many

ERD A customer submits one or many leads. A lead belongs to one customer. A lead is a request or an inquiry. A lead belongs to one manufacturer. A manufacturer has one or many leads. Tables ...
0
votes
1answer
20 views

database normalization to 3NF

I am just at a complete lost. I need help with this. There should be 12 tables (or perhaps 11 since one table has just a single attribute) when you are finished with the normalization and merging of ...
0
votes
1answer
36 views

When to use hashtable over binary search tree vice verse for Database Index

Database Index can be constructed using binary search trees (BST) or HashTables , From my understanding so far , HashTables are superior to BST in terms of time taken for searching and insertions ...
0
votes
1answer
52 views

mongodb on-premise: will it work?

We are planning to package MongoDB-PostgreSQL hybrid solution in our application that will be deployed on customer site on-premise. It will be packaged as a software virtual appliance. Our reason for ...
0
votes
0answers
14 views

Strange behavious with SET options in SSMS

I am investigating the effect of various SET options on the creation of indexed views on SQL Server 2014 CU1. The following code: ensures that the SET options are as they should be creates a table ...
1
vote
1answer
42 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
2answers
162 views

Is there a way to enable MariaDB MEMORY storage engine for every table?

I am new to MariaDB and interested in using it because I want to use MEMORY storage engine for every table. I read MEMORY storage engine on mariadb.com and it seems like I had to specify storage ...
0
votes
2answers
204 views

oracle sqlplus as sysdba startup error

Oracle 11g, PC: 32G,8 thread cpu. now three oracle instances has been running. but. sqlplus "/as sysdba" prompt connect to an empty instance. when I do startup command, come an error: ...
0
votes
1answer
316 views

How to perform ETL from RDBMS to Neo4j

I have a mature 50+ tables web application based on mySQL. In order to do some advanced data mining I want to use Neo4j and the goodnes of cypher. However I'm having a hard time migrating my data from ...
2
votes
1answer
434 views

what is '#' in create table statement? [on hold]

I have recently seen a statement like: CREATE TABLE #tbl_AR_Data I wanted to know what is the purpose of that symbol "#" (NUMBER SIGN, hash, pound sign) in this statement?
0
votes
0answers
37 views

SQL Server Perfmon % Processor Time unbalanced

I am somewhat of an accidental DBA, and I'm troubleshooting a SQL Server box where performance has been notoriously poor (as reported by the customer). I was not involved in the initial planning of ...
0
votes
2answers
19 views

Design for table with multiple links to other table

I am designing a database to keep track of our network equipment. My db has 2 tables: sites & circuits (circuit = cable) & (site = property location) Each circuit runs between two sites, so ...
0
votes
1answer
53 views

High Global Lock % on Mongodb

I've just started using Mongodb v2.4.8 and the global lock % averages 80% which seems rather high to me. The CPU usage is around 120% on a 2 core, 2GB RAM, SSD VPS running Ubuntu 12.04 64bit. iotop ...

15 30 50 per page