0
votes
1answer
10 views

Insert GEOMFROMTEXT (lat lng)

I am stuck, Please help. "INSERT INTO `routeplans` ( `polygon` ) VALUES ( GEOMFROMTEXT( 'POLYGON( (39.593254951279626 -119.2415714263916, 39.596231192849004 -119.2441463470459, ...
0
votes
1answer
21 views

Stacked Left Joins or Left Join inside a Subquery?

OK, this is a fun one. Designing a database for a gaming system. I have 3 tables that are relevant for the query I'm trying to work on right now. character_skill_log with the relevant fields of id, ...
11
votes
5answers
916 views

Why does a UNIQUE constraint allow only one NULL?

Technically, NULL = NULL is False, by that logic no NULL is equal to any NULL and all NULLs are distinct. Shouldnt this imply that all NULLs are unique and a unique index should allow any number of ...
0
votes
1answer
9 views

Postgresql two tablespaces one on SSD and one on SATA III HD

Continuing my previous question PostgreSQL maximize performance SSD the DBA SE community has given me efficient advice on optimal settings for PostgreSQL on SSD. The problem is that I will define two ...
0
votes
1answer
27 views

Cannot execute as the server principal

I'm trying to set up a stored procedure to execute an SSIS package. I want to allow a user to execute only this stored procedure, so I need it to run as a different user. I found this article which ...
0
votes
1answer
22 views

grant permissions in oracle from one database to another

I have two databases, employeedb and contractordb. The employeedb has a user called employeeuser and contractordb has a user called contractoruser. (These are the users I log in with in Oracle SQL ...
-2
votes
0answers
19 views

What goes well to link with java? MySQL or Oracle XE? [on hold]

I will be using Eclipse to build a web application. I am trying to decide on my backend database. I am familiar with Oracle DB but I have questions Will there be any issue in plugging in with ...
1
vote
1answer
38 views

Any known issues upgrading from MySQL 5.1.73 to 5.6.21?

I am planning my MySQL DB ver5.1.73 running on a CentOS 6.5 machine to MySQL 5.6.21. I understand the basic procedure for this based on what I have read on StackOverflow, but I was curious if anyone ...
-1
votes
0answers
11 views

Automated way to transfer fields from Oracle EPM to Student Access for TRIO Student Support Services [on hold]

(I apologize in advance for most likely posting this question in a wrong place...) I am one of the tutors in our TRIO Student Support Services program at school, and my supervisor asked me to explore ...
0
votes
1answer
12 views

postgres removing user from role membership

How do I drop a role member? My role name tester is member of role postgres (which I do not want). How do I remove this membership? Role name | Attributes | ...
1
vote
1answer
60 views

How does SQL Server handle logins when the user is a part of multiple groups with various privileges?

I'm trying to wrap my head around how SQL Server decides to grant certain rights based on a users login privileges. If a user is part of a group "READ ONLY" which has access to DB1, but they are also ...
0
votes
1answer
74 views

Applying normalization to a relational Database (Access & SQL Server)

This question is pretty specific but I hope it can get answered on here. There is a wide range of information about normalization but I feel what I have read so far isn't as effective as just stating ...
0
votes
0answers
27 views

DB Model for Small requiremnt [on hold]

I have created below DB model. Could you please validate if this is proper. This is restaurant app where waiter takes order and gives it to chef.Before placing order she does have information of ...
1
vote
1answer
22 views

SQL Server 2012 Install error “The instance selected for installation is already installed and clustered on computer…”

I am trying to setup a new environment for SQL Server 2012 AlwaysOn. I inadvertently used some SQL Server 2008 config files initially to do the installs but ran into too many problems. I un-installed ...
1
vote
2answers
64 views

Fourth inner join to the same table increases query duration significantly

As soon as I add a fourth inner join to a specific table, the query duration increases significantly: sub 1sec to 45sec. The table in question is deployments d4. The SQL Query: select a.id as ...
0
votes
1answer
39 views

Search NVARCHAR(MAX) string in other string

I want to find the index of a string in other string. I try to use CHARINDEX and PATINDEX but nothing worked because the search string is NVARCHAR(MAX) and these functions are limited to 8000 chars ...
1
vote
1answer
14 views

Importance of uniformity of hardware for Galera cluster

How important is it for the nodes in a Galera cluster to be identical? I've found this answer which says they should be the same: http://dba.stackexchange.com/a/55224/770 I understand that you ...
1
vote
2answers
37 views

What backup/restore strategy can I use for the following scenario

We have two databases on a server which are being synced using back up and restore on a scheduled basis. Now, we would like to exclude a few tables getting affected by the back up and restore process. ...
0
votes
0answers
20 views

285GB sonar db and growing, on mysql 5.5 [on hold]

we have a virtual machine that hosts Sonarcube v3.3.2 on mysql 5.5. With all our users, the database (sonardb) ended up being 30gb give or take. Later we decided to also install sonar 4.2 on the ...
-1
votes
1answer
61 views

Why is MySQL Server software so huge? [on hold]

How come MySQL Server software is bigger (in size) than SQLite? What makes it so big? Isn't it just about some network protocols and code that comes to save the tables and its entries? SQLite, with ...
0
votes
0answers
13 views

Mysql select using regexp

I have some user input i am receiving from some forms exactly in this format Names#Age#Gender#City The problem is,some forms come with incomplete data which is acceptable during the filling of the ...
0
votes
0answers
23 views

Oracle Duplicate Database with no archived logs

I am trying to perform a duplicate operation from one server to another (testing disaster recovery) on oracle 11g. I am very much still learning about Oracle. The system is not in production, it is ...
0
votes
3answers
43 views

Performance first low, then high after adding index, then keep high after drop index

I am testing performance a complicated select query. It is very slow. using explain, I have found a ALL in type COLUMN. Then I ADD INDEX. result comes out fast. However, when I DROP the INDEX I ...
0
votes
0answers
8 views

ORA-27100: shared memory realm already exists oracle

I'm trying to start our db after performing a shutdown abort on a oracle 10g server, but atm i'm getting the following message: ORA-27100: shared memory realm already exists Linux Error: 17: ...
0
votes
1answer
14 views

create foreign keys for pivot tables

I'm trying to optimise and speed up a mysql 5.6 datatabase. I have two tables with a many to many relationship: Reservation and Resource. Each Reservation can have many Resources and each Resource ...
2
votes
2answers
38 views

Oracle: Helping hand writing this query. Do I need a sub query here?

I have the below query that returns the number of orders created on a particular customer number per month for the past 2 years. SQL SELECT TO_CHAR(o.entry_date, 'MM'), SUM(CASE ...
0
votes
1answer
24 views

database roles name convention [on hold]

i want to ask if there is any name convention for sql server database roles, what is best practise or what i should follow. We have databases and a lot of people and i want to suggest some rules. ...
1
vote
1answer
24 views

group records according to column

hi how can make this result query: to this: I have this code and i know it's still farfetched: select max(case subcod when 'DISABILITY' then A end) as disability, max(case ...
2
votes
2answers
183 views

Join 3 tables and return only distinct values for max datetime

I've been trying to do this the whole 2 weeks but seems like to no avail. 3 tables involved here. but am expecting the result would be distinct case no. for the same date & user. otherwise, it ...
1
vote
1answer
20 views

Slow postgresql query with pagination and filtering

For the DB in question, I have followed the advice of Pagination Done the PostgreSQL Way That is, results are being paginated on a composite index with a definite sort order. Now, my problem is ...
-1
votes
1answer
22 views

SQL Server 2008R2 Profiler missing [on hold]

I am using Microsoft SQL Server 2008 R2 (RTM)(X64) But in that Profiler is not visible in Tools option, 3 to 4 time I uninstalled and re-installed SQL Server, then also not able to see the ...
0
votes
1answer
15 views

how to change sybase sql default port

Is there any option to change the sybase sql default port ? Here I want to change the port number because we can't start two SAP instances at the same time on the same server?
0
votes
1answer
26 views

What can cause mongodb used memory to increase?

We have a MongoDb instance which contains two main db use about 30G of disk. >show dbs; admin (empty) l_comment 17.945GB l_recommend 15.946GB lifeix_relation 1.953GB ...
0
votes
3answers
21 views

Mysql Create table shows ERROR 1005 errno 150

I am trying to make a junction table, but I getting a ERROR 1005 errno 150 CREATE TABLE 61furiousFistPokemon( cardNumber int NOT NULL PRIMARY KEY, pokemonName VARCHAR(12), type VARCHAR(10), stage ...
1
vote
1answer
21 views

Integrity constraint violation in Percona XtraDB Cluster

We have a PHP application that uses AWS Load Balancer that connects to 3 Percona Servers. Before we used a single standard Percona Server and that never happened. The cluster starts throwing Primary ...
0
votes
1answer
71 views

Why can't modern databases have unlimited columns [on hold]

I am just curious as to why big open source and commercial RDBMSs can't, don't or won't implement unlimited columns per table? Is there a technical or business reason why this can't be done. MongoDB ...
0
votes
1answer
37 views

Query to convert existing rows to columns [on hold]

I am new to mysql and require help for reverting mysql data from rows to columns some explanations as pivoting are not working for me and i have tried multiple times ----------------------- |CODE ...
0
votes
1answer
25 views

I noticed that my MySQL slave's DB size is smaller than the Master's DB

I have a very simple setup of a master MySQL DB with one slave MySQL DB replicating from it. Initially, when setting up the slave, I used mysqldump to get an initial DB dump from the master like ...
0
votes
1answer
14 views

MySQL update one table from another joined many-to-many

I have two tables, events and plays joined many-to-many by a third table plays_in_events. Where the events.Name field is blank, I want to set it equal to the name of the play that was performed in ...
1
vote
1answer
47 views

How to restore SQL Server 2008 R2 database to newly installed SQL Server 2008 R2 instance?

Our SQL database server recently suffered a serious OS failure and had to be reinstalled from scratch. We are now attempting to associate the restored database and transaction log files into the new ...
1
vote
1answer
38 views

Is there a faster way to get OR behavior in Postgres?

Is there a faster way to do an inner join with an OR clause. I have a query that looks something like this: INNER JOIN (select u_id, b_id from t1) AS t2 ON t2.u_id = t1.u_id OR (t2.b_id = ...
0
votes
0answers
34 views

MySQL has gone away with two connections

I'm using MySQL 5.6.19 on OSX 10.9.5 (DMG installation from mysql.com) and I'm receiving the infamous MySQL has gone away when I try to open two connections to this server. If I try connecting from ...
0
votes
1answer
44 views

SQL Server 2008 and constant expressions

If I have the following scenario, would Replace be evaluated a single time? DECLARE @text nvarchar(32) = 'This is a test field' SELECT textField FROM Table WHERE Id = @idICareAbout AND textField = ...
0
votes
0answers
21 views

Receiving duplicate results in one condition of JOINED query

I always end up here when Googling for solutions, so I thought I'd cut out the middleman since I'm unable to fix this via searching/forums. It's my first time posting, so please forgive any faux pas ...
0
votes
0answers
16 views

Is there a function in excel to recognize a maximum in a cell [migrated]

I am using excel to track participants for a large workshop day, recording which workshops people have signed up for. I have created formulas using the "COUNTIF" function to tally how many people have ...
1
vote
1answer
8 views

Why MySQL init_connect variable gets updated after rebooting?

After SET GLOBAL init_connect=''; query everything works fine. However after rebooting the server or restarting the MySQL service it updates the init_connect value to some random value (OÇÿOÇÖ). Do I ...
0
votes
0answers
27 views

SSRS URL Changes while navigating

I am trying to track down the root cause of this issue I keep seeing. We have SSRS running with a custom URL like https://reporting.companyname.com/reports. When I connect to that address I can ...
0
votes
1answer
34 views

How to list objects that are using another object?

I have to move certain objects from a schema to another. The database is rather large and I want to make sure we test properly all affected objects. On TOAD there is a Tab called "Used By" that show ...
1
vote
1answer
30 views

Impact of using UUIDs with an UNIQUE index vs. PK?

It's well known how the performance of random UUIDs as PKs in an InnoDB table degrades terribly as it increases in size. Would an UNIQUE index for a non-PK UUID column have the same impact? UUIDs are ...
0
votes
1answer
53 views

Is it possible to trace the password the application is attempting to use to connect?

I have an application attempting to connect to SQL Server. The application connects using a SQL Server account. The password for this account was accidentally changed. Now the application is ...

15 30 50 per page