2
votes
3answers
50 views

Additional space required for INDEX REORGANIZE

MSDN states: ALTER INDEX REORGANIZE; however, log space is required. The database recovery mode is Simple, does that implies the log space is actually NOT required ?.
0
votes
1answer
15 views

How to limit results using join in SQL in php [on hold]

I have one table of comments and a second table of students. I want to limit results from these tables using a simple join but I don't know how to. My query is like SELECT com_des,com_doc,usr_name ...
0
votes
1answer
13 views

How to limit schema size by a trigger

The problem: I am running on a Webhotel a MySql database with different schemas with a maximum size limit on each schema. I can't change any settings on the DBMS. To be able to keep the schema below ...
-1
votes
0answers
18 views

dynamic table can't be accessed by the users [on hold]

i have created a dynamic table within the stored procedure and granted access permissions for the particular table and stored procedure to the corresponding users and it will get from the out variable ...
1
vote
1answer
32 views

MySQL repair deleted data - Any chance of recovery?

Well, this has been a long Saturday morning. MySQL was throwing an error when dumping backups. That error was... mysqldump: Error 1030: Got error 5 from storage engine when dumping table mytable at ...
-1
votes
2answers
41 views

How is SQL used from an end-user perspective? [closed]

So I've been learning database manipulation and design and using SQL, but surely a secretary of a company wouldn't be using SQL to directly enter things into the database, so how does that work? For ...
0
votes
1answer
13 views

Correct place to put very large text field for mysql/mariadb

I have an app where a queue is being processed, Each time an entry is processed the result is stuck in a separate table. The queue table gets inserts and updates, the result table inserts only. The ...
0
votes
1answer
17 views

Postgres blocking UPDATE on new column?

For the life of me, I can't figure out why Postgres won't let me issue this update statement below. Assume any table called dim_dates where there's a column dateType: ALTER TABLE dim_dates DROP ...
1
vote
0answers
40 views

innodb slower much slower than expected

Trying to figure this one out and I apologize for not providing a lot of information from the start (if you need further let me know and I can try to provide it). Query is performing very poorly - it ...
1
vote
2answers
32 views

Configuring sqlnet.ora and tnsnames.ora on the client side

I have an application server talking to an Oracle database, using the Oracle instant client. We are troubleshooting a specific bug, and it was asked if I could add the following flags to to my ...
0
votes
1answer
44 views

How to set a restart on a TSQL Job?

I currently have an important TSQL job that hangs probably once a week. It moves data from one database to another. It is on a schedule running every 5 minutes indefinitely throughout the day. ...
-1
votes
0answers
22 views

PostgreSQL how to change to Repeatable read [on hold]

I'm running a postgreSQL 9.3 database and I have stored procedures in it. I access the database using JDBC with Java calling the stored procedures with prepared statements. I know that the default ...
0
votes
0answers
15 views

Oracle SGA memory areas [on hold]

Why is it that when we startup Oracle instance we get four SGA areas listed (refer to figure), but when looking at Oracle documentation on Memory Architecture there are six respective sections, ...
2
votes
1answer
29 views

Best way of finding rows referencing a given id on PostgreSQL

I'm trying to find if there would be anything violating the foreign key constraint when deleting a row, to check if I can delete it or not (can't use ON DELETE CASCADE) For that, I have a piece of ...
0
votes
1answer
27 views

Oracle Standby Database - Archivelog GAP

Good Afternoon! I've done some research around fixing archivelog gap between Primary and Standby databases, and a few links provide tips on the querying V$archived_log, v$archive_gap and ...
0
votes
1answer
13 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
23 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
1k 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
14 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 ...
1
vote
2answers
170 views
+50

Issues with module signing and SSIS catalog internal procedures

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
26 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
24 views

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

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
65 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
13 views

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

(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
13 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
65 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
91 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
30 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
32 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
69 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
42 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
18 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
39 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
27 views

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

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 ...
0
votes
1answer
65 views

Why is MySQL Server software so huge? [closed]

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
20 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
34 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
48 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
12 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
19 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
52 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 [closed]

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
26 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
191 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
33 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
24 views

SQL Server 2008R2 Profiler missing [closed]

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
17 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
37 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
25 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
31 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 ...

15 30 50 per page