0
votes
0answers
3 views

When enable authenticating in MongoDB, how to use mongo_fdw?

I test mongo_fdw these days, It's ok when mongodb disable the auth authenticate, but if the mongo enable the auth authenticate, should we create a mapping user for the foreign table? what shoud we ...
0
votes
1answer
7 views

Locating a schema that owns a role

Let's say we've logged on under the A schema. I am able to execute the following statement grant select on wph_pden to LANDING_R; However, the LANDING_R object can not be located in the schema A. ...
1
vote
2answers
10 views

Aggregating results of two database views in one database view

I have a view with name of UserInfo like this: And another view with name of UserRoleInfo like this: I want to aggregate all the records of the two views for one user name like H.F into ...
0
votes
0answers
11 views

Word frequency query in Greenplum

What is the query for word frequency and word count, word occurance and pattern search in Greenplum?
0
votes
1answer
15 views

Rows into Column

I want to make the above view vConsolPrchOrd like below: Database: PostgreSQL 9.2 I want to create a Crystal Report with this view (I asked about this on Stack Overflow).
1
vote
1answer
20 views

Am I using the ORDER BY clause incorrectly

I am trying to enumerate a database, created specifically for the purpose of learning SQL injections. I am trying to discover the number of columns a particular select statement might be using. I do ...
0
votes
0answers
6 views

How to move MySQL 5.6 data file on Windows 7

I don't get it. I am administrator on my machine, but I cannot move the data files. I get access denied errors when I attempt to. There was no my.ini in C:\Program Files\MySQL\MySQL Server 5.5, so I ...
0
votes
0answers
7 views

Can't run subqueries on my server (MySQL)

I have a weird problem, where I can run sub-queries just fine on my local machine, however they seem to be hanging forever when I attempt to run them on my server. Note that my server has plenty of ...
-3
votes
0answers
9 views

mysql store procedure select promblam [on hold]

delimiter // DROP PROCEDURE IF EXISTS aProce; CREATE PROCEDURE aProce(IN FIRSTDATE DATETIME, IN LASTDATE DATETIME, IN CONSIGNERS VARCHAR(255)) LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY ...
0
votes
0answers
8 views

MySQL migration to new hardware + upgrade + huge DB + windows

I am relatively new to DBA work and have a critical task in front of me, I really appreciate any detailed help you could offer. What I have a is a roughly 340 GB MySQL database on a Windows server. ...
0
votes
0answers
29 views

Parking Lot table for employees

I am having dificulty designing a table that stores the information about a parking lot with 100 spaces that are arranged by 5 columns x 20 rows for employees, guests, handicap, executives, ...
1
vote
1answer
15 views

PostGis getting rid of the lat long from table

This question is related to this question : Order by distance Now my tables have changed a bit. Table cafes now doesn't have latitude, longitude columns instead there are table addresses which ...
1
vote
1answer
20 views

Oracle Automatic Memory Management - SGA_MAX_SIZE

When using Automatic Memory Management, what value should SGA_MAX_SIZE be? Should it be 0? These are my current settings, and I'm unsure whether to leave SGA_MAX_SIZE or set it to 0. ...
1
vote
1answer
19 views

Update all columns from another table

I need to update a table from another one, and I need to update all columns. Besides listing every column in the SET clause, is there a way to update them all at once? Like this: update tableA set * ...
1
vote
1answer
24 views

Nested query efficiency in MySQL

I have a table with several attributes like this: id id2 attribute -------------------------------- 1 100 blue 2 100 red 3 100 green 4 100 white 5 102 blue 6 102 green 7 102 ...
0
votes
0answers
29 views

Why SQL Server syntax is not available in diagrams ? [on hold]

(New to SQL Server) Oracle and SQLite documentation gives SQL syntax in form of diagrams, for example: SELECT in SQLite http://sqlite.org/lang_select.html vs SELECT in SQL Server ...
-2
votes
1answer
28 views

CTE statement to delete duplicate rows - what's wrong with this statement? [on hold]

WITH CTE AS( SELECT set_name, table_name, cfg_name, col_name, col_row, delete_id, recovery_unique_id, RN = ROW_NUMBER()OVER(PARTITION BY set_name, table_name, cfg_name, [col_name], col_row, ...
0
votes
2answers
20 views

Hidden user rights

I'm running SQL Server 2008 R2 SP2. I have a SQL Server user, that the application uses to connect to my database. I've removed the user from all roles except public and the login from all database ...
1
vote
1answer
16 views

UK Addresses in 3NF

I am in the process of creating a UK only database which holds information for various sets of people i.e. Staff, Clients etc. The tables for each of these sets of people have an Address, City and ...
1
vote
1answer
21 views

Help with out-of-range value

I have this query that is giving me an error The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. Query: select COUNT(*) from dbo.patient ...
0
votes
0answers
7 views

How much the decision to use ternary or binary relationship influences the accuracy of the model with regards to a given business model?

The question title is very long, so here's a little bit of context to (try to) make it clear. I asked a question regarding ternary relatinship. The question was Ternary relationship: what's the ...
0
votes
0answers
10 views

What is the “SQL Agent - Generic Refresher”? Do I need it?

In relation to my other question: Why do connections to my database fail, but only sometimes? (more details of the specific problem are here). What is the SQL Agent - Generic Refresher service? It ...
1
vote
2answers
29 views

What is best way to handle transaction in sql server when inserting in 15 to 20 tables in one batch

What is best way to handle transaction in SQL Server when inserting in 15 to 20 tables in one batch. Currently I am using single transaction for multiple insert statements in stored procedure.For ...
0
votes
1answer
19 views

How to create and start a PDB for RCU in Oracle 12c

So I've made a fresh install on a virtual machine based on OEL 6.5 x64. All my installs are in /opt/apps I installed a Oracle Database 12c, with the Desktop Version selected (not server), UNICODE ...
1
vote
1answer
47 views

Why do connections to my database fail, but only sometimes?

I am having some trouble diagnosing the cause of a problem I am having with Microsoft SQL Server 2008 R2. There is an application written in C#.net that connects to the database. Occasionally the ...
0
votes
2answers
35 views

Is there a simple, safe and low cost way to implement a (limited) database to be outside (close) IT control?

This question is a spin off of the discussion here (What are the risks of building a database outside IT control?). Background: I'm a risk guy that builds little betas, mostly in Excel-VBA. I have a ...
0
votes
1answer
18 views

Change posgresql 9.3 slave roll password

I need to change the password on my slave posgresql server, because the person who set it up left the password the same as the password for the super user account on our other server. When I run ...
0
votes
1answer
24 views

Schema Migration for application upgrades

I have an application which is running with an application schema on Oracle DB. The application needs to be upgraded to new version of Schema on Oracle DB with changes in Schema structure (Table ...
3
votes
1answer
27 views

Oldest unsent transaction alert for Availability Group

In SQL Server 2008 when using database mirroring, it was possible to set up alerts when the oldest unsent transaction exceeded a certain threshold. We could check the state of any database mirroring ...
1
vote
3answers
45 views

Two MySQL Server accessing same database over NFS

I want to run two separate MySQL instances on two separate machines, but using same data directory over nfs, is it possible with InnoDB Storage Engine? Application operation will assure the following: ...
3
votes
4answers
183 views

How to check for existence of an INDEX on a column independent of used SQL database

Is there are unified way of how to check for the existance of an INDEX for a given column irregardless of the actual SQL database system used? For MySQL one could for instance check for the existance ...
-2
votes
0answers
16 views

How to fix ERROR Postgresql * Removed stale pid file

My postgresql server 9.1 suddenly crashed. When I try to start server it shows me error tejastank@snippetbucket:~# sudo /etc/init.d/postgresql restart * Restarting PostgreSQL 9.1 database server ...
-2
votes
0answers
37 views

cant pass table name as argument in a same procedure

delimiter $$ create procedure proselect (IN tname varchar(20)) begin set @s=concat('select * from ',tname); prepare stm from @s; execute stm; end $$ call proselect('table1') ...
2
votes
2answers
22 views

Can creating indexes colide with future database upgrades?

I have a mysql Database with very slow querys. I am using the slow query log to monitor those. This is a database created by a third party software that we're using. Their developers didn't do any ...
0
votes
2answers
29 views

Snapshot replication - How to detect when a snapshot has arrived on the Subscriber from the Subscriber DB

I have snapshot replication set up to on a server which publishes to a second server as part of a scheduled SQL Server Agent job. When the snapshot finishes, I would like to detect when each table has ...
-1
votes
1answer
13 views

MySQL 5.7.4 Startup Times Out

I recently upgraded the MySQL Server installation on my Windows 8.1 Pro x64 laptop from 5.7.3 to 5.7.4 using the MySQL Installer, and after doing so, attempting to start the MySQL Server service, ...
0
votes
1answer
59 views

Why does this simple select statement require quotes?

Why does the following statement select * from expertrule where rule_id = '1'; Return this error ORA-00904: "RULE_ID": invalid identifier While select * from expertrule where "rule_id" = '1'; ...
2
votes
1answer
84 views

SQL server query is slow *without* including execution plan

I have just set up fresh installation of SQL Server 2012 on a new server and I'm experiencing very strange performance problems. Long story short, for some reason not including execution plan makes my ...
0
votes
0answers
18 views

restoring huge MySQL database would location of sql file on a mount significantly slow restore (linux)

Hi I neglected to move the sql file from the mount before starting the mysql -h localhost -u root 'my_data' < /mnt/mirrorserver/huge.sql and the restore has been running all night as my mysql ...
0
votes
0answers
12 views

Linked Data graph database - best solutions for scalable RDF graph database

I am building a Semantic Web application that performs recommendations, etc etc, and I'm looking for a scalable database that can be deployed to a cloud hosting service easily (like AWS). In the past ...
0
votes
0answers
16 views

How to make a role from schema A “grantable” in schema B

There are two schemas in the same database: A and B. Schema A has a role A_ROLE. I want to be able to give grants to A_ROLE from schema B ( so that the users with A_ROLE were able to query tables from ...
0
votes
1answer
16 views

Are the contents of all control files the same?

I understand that one needs to multiplex and back up the control file. Also one can have multiple control files in the database instance parameter setting. If one of these files get corrupted or is ...
-1
votes
0answers
13 views

Oracle 12c installation error on windows 8.1 x64

The following error is getting while installing Oracle Database 12c on my local pc. I have only one user account and I logged on as administrator. I also tried Run as Administrator to the setup.exe. ...
1
vote
1answer
21 views

What does this mean - ~/.my.cnf

When I run $ mysqld --verbose --help | less I got information like Default options are read from the following files in the given order: /etc/mysql/my.cnf /etc/my.cnf ~/.my.cnf As per my ...
1
vote
1answer
27 views

Ternary relationship: what's the difference between having single table and having multiple tables?

Consider the following ternary relationship: Suppose that all entities have only two attributes (PK and Name). Here are the tables I derived (5 tables): Sector ------------------------- ...
0
votes
0answers
17 views

Conversion of simple ERD to Table: is the solution below any good?

Consider the following ERD: Suppose that all entities only have two attributes: a PK plus a name/number. I want to convert that ERD to tables. Is it needed 4 tables (1 for each relationship ...
1
vote
0answers
27 views

Tools and techniques for untangling monster views (nested views)

First a bit of context (venting). I'm working with a new vendor product which is really nothing more than a SQL Server database with a .NET interface. First few weeks with this client and users are ...
0
votes
1answer
23 views

High volume data aggregation

I need to aggregate incoming data and save the resulting aggregates to a table. A sample of the data is below. id,time 1967,2014-04-12 00:42:55+00 1967,2014-04-12 00:42:51+00 1972,2014-04-12 ...
0
votes
2answers
40 views

SQL Server 2008 - How to schedule a copy of view to another database?

I am a Sharepoint admin and need to copy the log data in database to another temp database for analysis. The data is stored in a view ([WSS_Logging].[dbo].[RequestUsage]). There is a column [LogTime] ...
0
votes
0answers
10 views

TokuDB fails to load in MariaDB, even when transparent hugepages are disabled

Earlier, I upgraded my website server to Ubuntu 14.04 LTS. I had a very nice setup with MariaDB and the TokuDB engine. However, the setup was kind of messed up when TokuDB refused to load properly, ...

15 30 50 per page