0
votes
0answers
3 views

Slow query while selecting a higher offset from millions of rows

I have sort of security log files containing millions of rows. On my current testing I imported the data for one month which is the sum of ~14,000,000 records. The table contains several set of fields ...
0
votes
0answers
8 views

NoSQL DBs and 2-way synchronization

I've been told that MongoDb does not, but do any NoSQL DBs support this functionality?
0
votes
0answers
7 views

NoSQL: quorum vs sharding

After reading about few NoSQL techniques it looks for me that Quorum fails comparing with Virtual Sharding. Virtual sharding allow scalability and does not increase amount of read/writes across a ...
0
votes
0answers
15 views

Big difference between id value [duplicate]

I have this database table where I insert multiple results during 1 action. In php I have a submit button when pressed, inserts 1-50 rows(depending on the user input). I've got a foreign key in this ...
1
vote
1answer
17 views

Where has STATMAN gone in SQL Server 2014?

So we've recently upgraded our environment to SQL 2014 (Enterprise on CU5) and are having some problems diagnosing performance issues, compounded by the problem that we no longer seem to be able to ...
1
vote
0answers
28 views

Update taking too long

I am updating a table with 250 million rows in SQL Server, and it's been running for 4.5 days. I'd like to use the computer it's running on for other memory-intensive work, so I'm torn about whether ...
1
vote
1answer
10 views

Does MongoDB support two 2-way synchronization

We are looking at moving our data from IBM Domino to another backend. One of the things Domino does really well is replicate (or synchronize as they call it) between a Server and Clients. That means ...
0
votes
0answers
8 views

MySQL (ndb) Cluster and BLOB Datatype access issue

I'm currently investigating moving our INNODB database to an ndb cluster (vs buying bigger servers (again) and moving the master / slaves to these). So far my testing on a small cluster has been ...
0
votes
0answers
5 views

OCIEnvCreate failed to create environment handle after installing oracle_fdw

I'm want use Postgresql 9.3 in CentOS 7 and add extention oracle_fdw. but when use this extenstion i get error OCIEnvCreate failed to create environment handle after installing oracle_fdw. my ...
0
votes
1answer
29 views

run a script for all databases

I need help what statement or function i can use to run a query in all database using one script , i want to run the below script at the same time to retrieve output in all databases select ...
1
vote
1answer
30 views

Tempdb growing, however it has a lot of free space

On a sql server dedicated to a Dynamics CRM database, I've been seeing some odd behavior. While monitoring growth using the following query as basis, I've noticed tempdb has grown quite frequently ...
0
votes
0answers
12 views

How to fix my Merge Replication upload order?

I have several Merge Replication instances in production on SQL 2008 R2. One of them has started to behave oddly in that it appears to attempting to upload the children tables before it uploads the ...
0
votes
1answer
28 views

Alter column opreation failed due to disk space in SQL Server

When i apply alter column on table, it full log file and disk too, and fails alter operation. Why this happened even table size is less than free disk? Can anyone please suggest a way to complete this ...
0
votes
2answers
32 views

Duplicate data in a table given table name

For a performance testing application we need to have lot more data in our tables than what we have now. How do I duplicate the data in a table. In the process of duplicating I also need to set new ...
-1
votes
2answers
25 views

Cannot connect in SSMS with Windows Authentication

I found and added the server name through <Browse for more...> -> Network Servers so it exists and is correct. What seems weird is that the Password field is empty and I cannot modify ...
1
vote
2answers
42 views

How to speed up mysql export and import

I need to perform a DB migration from Server A to Server B. Server A: MySQL version installed 5.0.6 Server B: MySQL version installed 5.6.20 OS: Both are running RedHat Linux 64bit. 16 ...
0
votes
1answer
17 views

Is PDO_OCI classed as ODBC?

I did post this question at Is PDO_OCI (PHP PDO using Oracle Instant Client) classed as ODBC? anonymously, but then it wouldn't allow me to comment on it so I registered and am posting it again here. ...
0
votes
0answers
12 views

Change Tracking clenup

Is there a way to know when cleanup of change tracking tables occurs? How to check last occurrence of cleanup process? BACKGROUND: I have Change Tracking on database (retention = 1 minute): ALTER ...
-3
votes
2answers
63 views

Incremental BackUp in sql server

I got a task for backing up my clients data through internet. Client has about 50gb of data there. So I need to back up the data and pass through internet, But it takes about 8 to 9 hours for this ...
0
votes
0answers
16 views

How can I run a SQL 2000 database on SQL Server 2005 Express with a different location for files

I am trying to help a client out after a server crash. The temporary replacement server has different drive letters and data file locations. Here are the system details as I understand them: ...
0
votes
0answers
29 views

ON DELETE CASCADE not deleting entry for foreign key

I am running the below query in ideone CREATE TABLE AUTHOR ( AUTHOR_ID NUMBER(5) PRIMARY KEY, AUTHOR_NAME VARCHAR2(18) ); CREATE TABLE BOOK ( BOOK_ID NUMBER(5) PRIMARY KEY, BOOK_NAME VARCHAR2(15), ...
0
votes
1answer
14 views

ERD to data structure

I'm new to databases. I converted my ERD to data structure. Althougt I made sure all the 1NF, 2NF and 3NF are handled, I'm skeptic about it. This is the data structure. Port(PortID(pk), Name, ...
0
votes
0answers
5 views

Issue using COPY command with AWS Redshift

I am trying to copy a CSV file from my PC, which has SSH running, to AWS Redshift. I have copied the Redshfit public key to authorized_keys for the appropriate user. copy contact (id,name) from ...
0
votes
1answer
17 views

Oracle SQL Summing Values From Two Different Tables

Hey all so I am trying to add to (or subtract from) a column of different values based on a separate column in another table. Here is a example of what I am tying to do: Table 1: (Current Inventory) ...
0
votes
1answer
24 views

Pros and cons of using many schemas in PostgreSQL as opposed to just one?

For a large SAAS application (backed by PostgreSql 9.4), with over 300,000 accounts (and growing), what are the pros and cons of using a schema per account to partition the data vs putting all the ...
0
votes
0answers
14 views

Postgresql Multiple Processes and Queries or Nested Query? [on hold]

I have a series of tables and queries I run a process against and at times this process can take hours - if not multiple days - depending on the date range I select. I am running PostgreSQL 9.4. In ...
0
votes
1answer
26 views

ORA-01078: failure in processing system parameters LRM-00109 error too

SQL*Plus: Release 11.2.0.1.0 Production on Sun Mar 1 16:40:07 2015 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORA-01078: failure in ...
0
votes
0answers
18 views

11.2GB text file import MySQL or PostgreSQL

I am out of my depth a bit perhaps but submit this query hoping someone has some experience importing large (11.2GB) tab delimited text file (2.2GB tar.gz file) into either MySQL 5.5.41 or PostgreSQL ...
-1
votes
1answer
25 views

How to define one to many relationship in MS SQL database [on hold]

How do I create the relationship that is defined in above image. I have created two tables both has ID as primary key and it auto increments.
0
votes
0answers
12 views

Restore database from tape error 15105, cannot open backup device

I'm using HP Data Protector software to backup my SQL databases. When i try to restore a database from tape i get the following error. When i click on script, it says this: RESTORE DATABASE ...
0
votes
2answers
43 views

Question about choosing primary key

My scenario is that I have a super type named PERSON and two sub types EMPLOYEE and CUSTOMER. I use the Primary key from PERSON, PersonID, in both EMPLOYEE and CUSTOMER as foreign keys. However, I ...
-3
votes
1answer
38 views

Ola Hallengren Index Optimise Script not Rebuilding Indexes [on hold]

I have downloaded Ola Hallengren's script and deployed to master database. I run it using the below... EXECUTE dbo.IndexOptimize @Databases = 'USER_DATABASES', @FragmentationLow = NULL, ...
0
votes
0answers
18 views

Windows Administrator doesn't have permission on SQL Server [duplicate]

My previous system administrator created a SQL Server 2008 instance on my local machine with his domain User. Now, I cannot create, delete, or view any databases or tables on that instance. Even with ...
0
votes
2answers
30 views

How can I use 'system pwd' command with MySql CONCAT() function?

How can I use 'system pwd' command with MySql CONCAT() function? I tried select concat('test', system pwd); gives me ERROR 1583 (42000): Incorrect parameters in the call to native function ...
0
votes
0answers
2 views

how to open pg_xlog file in Pgadmin 3 with postgresql? [on hold]

Iam very new to this pgadmin 3. i have a problem on how to open pg_xlog files. kindly help to my query.
-3
votes
1answer
18 views

I cant find compiled versio of mydumber for mysql backup in windows [on hold]

I cant find mydumper (compiled) for windows, please dont address me for not compiled for windows . thanks
0
votes
4answers
24 views

Remote MySQL connection fails (10060) - “Can't connect to MySQL server on domainname.com(10060)”

I have developed one application in vb6, and i am using online MySQL database server for storing my application's data. So when i am try to connect with my database server,when first time i connect to ...
2
votes
1answer
25 views

Cannot SUM datetime field in Sql Server migrated from Access

I am new here and am new to SQL Server (Express). I used the SSMA tool and it converted Access date/time fields to datatime2. The data contains duration data so there is no need for a date. I want ...
0
votes
0answers
10 views

Failing to ensureIndex on sharded Mongo

I run a mongoDb, sharding it on 4 different shards (+ 1 router and + 1 config). Sometime ago I had to replace a shard, and everything went ok. But now, every time I run: db.summoners.ensureIndex( { ...
0
votes
0answers
8 views

Redshift table not showing up in tables for schema?

On Redshift, why doesn't my table show up in the following query? It definitely exists, as shown by the next query I run. I want a way to list all tables for a schema: mydb=# select ...
0
votes
1answer
10 views

list of items or menu in mysql workbench

i am creating a database for an android tourism app. i am working on MySQL workbench, i want to create a menu in my database, for example i want to list the cities of my country, or list the ...
-4
votes
0answers
24 views

How do I untar a file on a host that doesnt use cpanel only phpmyadmin? [on hold]

I have a tar file that I have uploaded to my host(which happens to be godaddy), but I have found out that they will not untar the file for me or do they use cpanel, only phpmyadmin panel is used. How ...
0
votes
1answer
40 views

query slows down exponentially as table grows

I have the following query running on mysql 5.6 on my CENTOS server select tb1.field2, tb1.field1, tb2.field1 from dns.table1 tb1, dns.table2 tb2 where tb1.field2 = tb2.field2 and tb1.field1 != ...
0
votes
0answers
15 views

Is PDO_OCI (PHP PDO using Oracle Instant Client) classed as ODBC?

I have a question that's been concerning me for some time. We use Oracle at our company and we're about to upgrade to a newer release. I understand that Oracle have some additional licensing if you ...
0
votes
2answers
42 views

How to rollback transaction if row changed?

I am using Postgres 9.3. When I update row in a table my flow looks like this: Fetch old row (ex. SELECT * FROM tbl WHERE id = 1) Validate new data in scope of old data (old row fetched in point 1) ...
0
votes
1answer
6 views

extract state changes from snapshot-based archive table

I have a table snapshot, storing snapshots every time an object stored in another live changed one of its attributes. I need to find all objects that changed a specific variable to a specific value in ...
1
vote
0answers
26 views

MySQL 5.1.73-cll and engine MyISAM PRO AND CONS FOR THE FOLLOWING 2 'DELETE' APPROACHES [on hold]

For MySQL 5.1.73-cll and engine MyISAM what are the pros and cons for the following two possibilities of 'deleting' rows(let's say that a user want's to delete his profile/delete some of his products ...
0
votes
0answers
12 views

Connect java application with cloud storage using sql [on hold]

I want to create an application in java and I want to use online storage but how I can connect that application with cloud storage
0
votes
1answer
20 views

MySQL:How much aprox disk space required for bin_log of the 80GB of DB?

I had total 80GB of database in MySQL server,and there is huge amount of trasaction are happend on daily basis,I need to be enable a bin_log so I required a recommendation how much disk space is ...
0
votes
0answers
5 views

Granting permission on an altered table in Teradata

I have a table, which has two columns say A and B as part of the Primary index PI_AB. I have to alter the length of B column - increase it. I was planning to alter the primary index to just have A, ...

15 30 50 per page