0
votes
0answers
14 views

Get data from BLOB (BINARY) type field

I got a Firebird database which I need to convert to a SQLite one. I've connected just fine and was able to export VARCHAR, INTEGER, etc. data with a few lines of C# However there's this column ...
0
votes
1answer
16 views

Insert a file into PostgreSQL BYTEA field using PHP

The previous answers have been horribly complex for the scope of this project. I want to take the $_POST result as a variable and insert it into a BYTEA field of a table. $_SESSION['username'] = ...
3
votes
1answer
30 views

Do I need to stop the service to back up the database? [on hold]

OK. Noob alert here :) We have several database driven applications using MS SQL Express, Pervasive, MySQL, and some sort of flat file database. PostgreSQL "may" be added later. We have backup ...
2
votes
1answer
38 views

Postgresql not using GIN trigram index when performing non-ASCII LIKE query?

Steps to reproduce Create database CREATE DATABASE citiesdb WITH OWNER = citiesowner ENCODING = 'UTF8' TABLESPACE = pg_default LC_COLLATE = 'C' LC_CTYPE = 'C' ...
0
votes
1answer
43 views

data warehouse design help

I'm struggling with the design phase for a data warehouse. It's not the traditional sales example you find on MSDN or all books etc. I've been tasked with creating an education data warehouse, that ...
1
vote
2answers
29 views

Location of #th iteration of a character or a word in a sql text field

How can I get the location for the #th iteration of a character or a word in a sql server text field?
1
vote
0answers
27 views

Link up an ms access database to SQL Server 2008 R2?

I've installed the OLE DB Provider for JET by downloading this and installing it. I closed and reopened Microsoft SQL Studio, and connected to my SQL Server Instance. In <instance-name> ...
2
votes
3answers
64 views

Listing indexes and constraints

I am looking at a SQL Server database for an application I have inherited. I have not looked into SQL Server for approximately 10 years, so please bear with me. The database table I am looking at has ...
0
votes
0answers
21 views

While impoting 150 GB file on Amazon RDS, why connection is failing?

I am having Postgres database dump file of 150 GB on Amazon EC2 instance. While dumping the data on RDS from EC2 server I am getting error. The output of the command is as given below. It's giving ...
0
votes
0answers
11 views

Database mirroring partner cannot connect to witness

So, I am not sure when this started but at some point in my database mirroring configuration, one of the partners (currently the mirror) stopped being able to connect to the witness. This is a ...
0
votes
2answers
27 views

MySQL Slave not updated

This might be a duplicate of questions on the same problem asked before. But all the suggestions to the previous questions do not seem to work in my case. I have set up Replication using SSH Tunnel. ...
0
votes
0answers
18 views

A transport-level error has occurred when receiving results from the server. Semaphore timeout

I've searched around and I'll the questions seem to be old and none seem to resolve my issue. I'm running SQL Server 2012 Enterprise and experiencing the following issue: Msg 121, Level 20, State ...
0
votes
0answers
24 views

Is it Ok to have one table with two relations?

I have an event table that has two kinds of participants. Each event will have many participants of each type. Is it good form to have a separate table for each participant type, each related to the ...
1
vote
1answer
31 views

Tuning Postgres for Single connection use? Or is postgres wrong tool?

Any rules of thumb for work_mem, maintenance_work_mem, shared_buffer, etc. for a database that DOESN'T anticipate concurrent connections and that is doing lots of aggregate functions? I'm a social ...
0
votes
0answers
25 views

Update query taking 8x times in hot standby environment of Postgresql

I configured streaming replication (hot standby) and tested the update query on it. The update query is taking 8 times more when compared with stand-alone PostgreSQL (9.2 version) system. Some ...
2
votes
2answers
26 views

Relations between a imeid, sim chip, and account from a cellphone company?

I've never really had a cellphone (that I owned the account to...long story), but at work we have them, and we want to get a series of relations between accounts, devices (mifi's, tablets, ...
0
votes
1answer
30 views

Slow performance of remote restore

Over the weekend, I was participating in a DR test. On the database side, that meant restoring backups from the production system to the DR system. What struck me as odd about the performance of the ...
2
votes
1answer
22 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 ...
0
votes
2answers
24 views

Fastest way to create local copy of live InnoDB MySQL database?

We have a MySQL database (InnoDB) on our live Ubuntu 12.04 server which has grown quite large (25gb+). Every month or so we need to copy this database to our development machines to work on locally. ...
0
votes
1answer
48 views

Select one single row from table b for each row from table a

I have two tables: A(name VARCHAR2(20), type VARCHAR2(20)) and B (type VARCHAR2(20), ... (20 fields more)) I need to select a single row from B for each distinct name,type from A taking into ...
2
votes
1answer
27 views

How do I sort the results of a recursive query in an expanded tree-like fashion?

Let's assume you have a nodes tables like this: CREATE TABLE nodes ( node serial PRIMARY KEY, parent integer NULL REFERENCES nodes(node), ts timestamp NOT NULL DEFAULT now() ); It ...
1
vote
3answers
48 views

Inserting Serbian Latin and Cyrillic characters

I am using SQL Server 2012 Express as part of my asp.net development workstation. Database and table collation is set to Latin1_General_CI_AI. Attribute types are nvarchar(max) and varchar(max). ...
0
votes
0answers
19 views

Why does MySQL randomly display my databases?

Using InnoDb for the tables, Zend installation that comes with MySQL on Windows. Basically what happens is that at each system startup (not MySQL) I get a random snapshot of my databases at some ...
-3
votes
1answer
28 views

How to avoid repeating values in a column in this case [on hold]

Dear Friends help to solve this problem The query is given bellow SELECT inv_val,ind_invno , ind_invdte, ind_csm_cd, csm_name, ind_fgm_cd FROM soh_invoice, sod_invoice, som_party WHERE inh_orm_cd = ...
0
votes
0answers
10 views

Is forwarding a port(s) a security risk to all computers on the network or just one? [migrated]

I know forwarding ports can add some security risk, but if i forward a port to a conputer running linux would it add a security risk to all computers on my network or just the one?
1
vote
1answer
32 views

Spy sql queries generated by an application

I need to know what SQL queries is generating some application. It is possible to see it in some kind of sniffer or what? I tried look in Management studio, but it shows only most expensivie queries.
-3
votes
0answers
34 views

SQL Server 2014 v/s NoSQL(MongoDb, RavenDb, CouchDb) [on hold]

Now SQL Server 2014 is out and there is lot of excitement regarding SQL Server 2014. How can we compare SQL Server 2014 v/s NoSQL(MongoDb, RavenDb, CouchDb)?
1
vote
1answer
15 views

Duplicate Data from two column

i have a table which has only two column one is pid(Photo ID) and another one is tid(Tag ID) +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | ...
5
votes
2answers
180 views

Why do Indexed Views not permit non-unique clustered indexes?

I've been looking into using Indexed Views to increase performance on a few of our most commonly used views. However Indexed Views do not support non-unique clustered indexes which goes a little ...
0
votes
1answer
9 views

How to create two same name databases in two different MySQL users?

I am using MySQL 5.5 running on Ubuntu 12.04. I have created two different users as 'root' and 'abc' and I want to create 'Items' database in this both user accounts but I want this two databases ...
0
votes
0answers
31 views

PostgreSQL DB size increasing after restoring the same database backup [on hold]

I have already asked this in stackoverflow. This is my batch script to take backup: @ECHO OFF d: cd Apps\RemedyStar 9.0 KREMCOS\bin\Debug\PG pg_dump.exe -i -h localhost -p 5432 -U postgres -F c -b ...
1
vote
1answer
34 views

Full text index search returns an unexpected result

When I search TaxIdentityNumber using contains an unexpected result is returned; the result contains numbers that are not matched to query. For example, I search using '"5689523657*"' and get ...
0
votes
1answer
14 views

SQL Server distrb.exe & Logread.exe using huge SQL.txt file in C:\Users\sqlsrvacct\AppData\Local\Temp folder

I have the following situation: SQL server 2008 R2 SP2 I have both the Distribution and Subscription database in this server. LogReader agent and Distribution agent are running in continuous mode the ...
0
votes
1answer
38 views

TSQL change column constraint between null and not null

I am doing a exercise to change a column's constraint between null to not null. Table name: Production.categoriesTest. Please review my question and give me suggestion on what I did wrong and how to ...
2
votes
2answers
44 views

Running query progress indication

I have a query: SELECT * FROM OPENQUERY ( oracle, 'SELECT * FROM [some_table]' ) It runs for about 7 hours. I only need to run this query once to import data into a new system when we ...
0
votes
1answer
18 views

Create previously created MySQL database without .sql file

I had a bad server crash in which I was able to restore my MySQL files, but I was unable to do a dump in order to get the .sql file. In other words, I have each individual part that was saved in the ...
0
votes
1answer
20 views

Impact of replication compression & encryption on performance, traffic?

What is the impact of MySQL compressed-slave-protocol on replication traffic? According to High performance MySQL it can lower the traffic to a third of the same replication without the compression. ...
0
votes
0answers
8 views

MySQL schema for recurring events - Query by specific date

I've just asked this exact same question on stackoverflow so apologies for cross posting but I only just noticed dba so thought I'd ask across here as well. I'm just about to start putting together a ...
2
votes
1answer
23 views

Space not reclaimed after dropping MyISAM table

I just dropped a rather large MyISAM table (~4 gb); it was 350k rows with about 11k of data per row. However, when I run df -h on my database server, I am still at 100% disk usage, so much so that I ...
2
votes
2answers
86 views

How slow is slow in postgres?

I'm working with postgres for the first time. I have a lot of experience with small / medium size data analysis (i.e. things that fit in ram and can be analyzed in R, Stata, Matlab, etc.), but am now ...
0
votes
1answer
24 views

Table join inheritance

I create db with Person, Client, Employee, Manager, Developer. I'm interested what is the best way to put the data in tables. In which cases should programmer unite Client in table hierarchy with ...
0
votes
1answer
12 views

MongoDb Sharding between replica and standalone server

So i got a replica set with three servers and a standalone server . I have enabled sharding between them. I inserted more data on replica primary server using "rockmongo". But the chunks are not ...
0
votes
0answers
22 views

Oracle edition-based redefinition

I have difficulty purging prior editions that clutter up my system: we deploy new code every 2 weeks, hence a new edition every time: ORA$BASE --> v37 --> v38, for example. I actualized all ...
2
votes
1answer
22 views

MySQL behaviour on connection failure

My MySQL database is hosted on a different machine from my application system, which issues queries to the MySQL database remotely. If for some reason the network connection between the two machines ...
0
votes
1answer
29 views

Is there way to have logical connection in MongoDB?

For example in oracle we can define tns.ora so client can connect with logical name. Although mongos can run on client servers, but when there are many different partner applications we we will need ...
0
votes
0answers
18 views

Concatenate extrapolated data from two tables

I want to concatenate two tables that contain user data. The purpose is to display the duplicate user accounts based on email, IP address and connection logs. The two tables containing user data (I ...
0
votes
0answers
8 views

How do I link two tables in access

I have created two separate tables and want to link them together so that you see all of the information from one table and then after that, all the information from another table. How do I do this?
0
votes
0answers
42 views

I'm unable to open a datafile in oracle, looking for a solution

I'm trying add more data into my schema, but I encounter the following error ORA-01116: error in opening database file 14 ORA-01110: data file 14: '/u01/oracle/oradata/REVA/ra_tbsp07.dbf' ORA-27041: ...
0
votes
1answer
34 views

Execute stored procedure in another server from sql agent job

I am trying execute stored procedure in remote server in sql agent job using sqlserver 2008 r2 select * from openquery([1.1.1.1],'exec [DB_Name].[dbo].[sp_ProcName]') Or EXEC ...
1
vote
1answer
35 views

Variable numbers of parameters in a SqlClr UDF or Stored Proc

Lets say I have the following signature for a CLR Stored Proc or UDF: [Public] public static void RaisError( string message, short severity, short state, params object[] args) ...

15 30 50 per page