0
votes
0answers
2 views

PL/SQL developer can't insert Unicode characters into oracle database

I've been meddling with charset/encoding problems of Oracle database and PL/SQL developer and these are what I have done: Change the server charset to AL32UTF8 Add system environment variable ...
0
votes
0answers
2 views

PostgreSQL Partitioned table update trigger

I have a date-partitioned table (inheritance partitioninng just like the one pg_partman does) which is referenced by quite a few tables in my database. To resolve the FKs checking for referenced field ...
0
votes
0answers
1 view

Set indexes for database used for login and register actions

I am thinking on how to set indexes to improve performance of a database for register and login actions.I have seen that alphabetical indexes are not good so I don't know how to do...Can you help me?...
0
votes
1answer
20 views

How to search by text in SSIS packages?

Is there a way to search by text in SQL Server Integration Services packages using T-SQL statement (or other language)? I want to check if certain table is used in any package as I am going to drop ...
0
votes
1answer
12 views

Access to folder is denied (log shipping)

i am trying to log ship from server A to B.I have done everything to configure log shipping but i try to run the job then at Server B while coping backup from server A gives me an error (can not ...
0
votes
0answers
8 views

Postgres “could not receive data from client: Connection reset by peer.”

I have a cakephproject got a error when the project reload and it seem the error Database connection "Postgres" is missing, or could not be created. I have checked the error it will show error could ...
0
votes
0answers
11 views

Can't script database from remote machine

I created a SQL Login (Login01), mapped to DB user (User01), member of db_owner database role. When connected locally with this user in SSMS, i try to script out the database (Script Database As -> ...
0
votes
0answers
18 views

Modify data using trigger

I have the following requirements in SQL server. I want to get updated/inserted values, edit it save to one column using SQL trigger. Say I have column named customer_name, when someone updates/...
0
votes
1answer
25 views

pgAdmin ||| paging?

I'm wondering if there is no paging feature for the pgAdmin III 1.22.1 Query tool. So if I try to query a table with 500k+ rows without constraints, the query takes like 30s. Is there a paging ...
1
vote
0answers
7 views

MySQL Innodb_row_lock_current_waits is 2^64 - 1

I have a MySQL 5.6 server which we monitor using Nagios. Over the weekend, it's started complaining about the Innodb_row_lock_current_waits, which currently has a value of 18446744073709551615, yes, ...
0
votes
0answers
12 views

MySQL keeps crashing

MySQL keeps crashing randomly - recent errors in error logs says this 160626 21:50:42 [Warning] IP address '113.108.21.*' could not be resolved: Name or service not known 160626 22:42:57 [Warning] IP ...
0
votes
0answers
8 views

Fail to connect from MySQL Workbench to remote server

After trying many different suggestions as found in the net, I'm still unable to establish a connection from the Workbench application to the server. Here is a brief list of things I tried: 1) ...
1
vote
1answer
10 views

Is mysqldump a “hot” backup kind?

I see in the documentation that the database backup tools are divided into four categories: hot backups, cold backups, physical backups and logical backups. I understand the the most important ...
9
votes
3answers
582 views

Why does this query work?

I have two tables, table_a (id, name) and table_b (id), let's say on Oracle 12c. Why does this query not return an exception? select * from table_a where name in (select name from table_b); From ...
0
votes
0answers
9 views

What exactly is MySQL Spin rounds per wait in SEMAPHORES section?

I am facing slowness issue on MySQL Slave. I am suspecting this due to OS I/O as i compared Spin rounds per wait values with PROD. Slave have higher values. Also slave has less resources compared to ...
0
votes
3answers
31 views

get datetime difference of a specific time and value of date time column

I have a datetime column in my mysql table. I need to get the difference between a definite time everyday say 12.00 pm and the value of that column.
0
votes
0answers
7 views

Progress of mongodump operation jams at a random point

We are executing remote mongodumps to backup collections. For some time now sporadically one of these dumps stops to progress any further and remains to log out the same amount of documents processed ...
0
votes
0answers
14 views

Expanding AlwaysOn Availability Groups with Replication Subscribers

I have query regarding "AlwaysOn Availability Groups with Replication Subscribers"... 1. can i add multiple publisher to subscriber(which is part of availability group as a primary server) ??? 2. in ...
0
votes
0answers
9 views

Repopulating PostgreSQL Database with Data Directory from Another DataBase Instance

I have had to delete PostgreSQL for an issue and reinstall it, however before uninstalling I did not execute the command pg_dump. I still have the data directory from this instance. After reinstalling ...
2
votes
1answer
34 views

Group by multiple columns with different members of the same hierarchy?

I have customer data in a table structure like this: customerID | productLine1 | productLine2 | productLine3 1 | 1 | null | null 2 | 2 | 1 | ...
5
votes
3answers
470 views

What is the effect of having an opened transaction in MSSQL for too long?

I'm just wondering what happens if you begin a transaction in a DB and forgot to commit or rollback it. Will the server be down? Lets say you left it for 3 days. There are also users who are using it ...
-2
votes
0answers
11 views

Collect statistics for whole SQL

I am quite new to SQL Server. I would like to collect some SQL statistics for the SQL Server, including Compilation/sec, Recompilations/sec and Batch Requests/sec. However, I have no idea how to ...
0
votes
0answers
5 views

Mongodb mmap private failed with out of memory

I am getting following error while tying to do write (from java) operation in mongodb 2016-06-26T18:11:46.426-0700 E CONTROL [conn2] mmap private failed with out of memory. (64 bit build) 2016-06-...
0
votes
1answer
13 views

Why is my statement results in a syntax error?

I tried to run this SQL statement in MySQL 5.5 and 5.7.1 but always got error. DELIMITER // CREATE PROCEDURE one_off_update_user_info_view_type() BEGIN DECLARE @batchsize BIGINT DEFAULT 1; ...
1
vote
1answer
13 views

Data Replication in Oracle

I have a table on master site which only allow insert operation. I want to replicate the rows which are inserted recently so, need something which can track the last record replicated into the local ...
0
votes
1answer
37 views

Stored Procedure Contradiction in book

I was reading the 70-461 TSQL training book and the part about stored procedures said this... "Variables declared in Proc1 and Proc1's parameters are not visible to any of the procedures called by ...
1
vote
0answers
9 views

get max item in sub query join mysql

i have a table it contain buy of each user , other table contain a star ranking According to buys all user, my scenario very sample i create it and show in sqlfiddle . example if in table buy have ...
1
vote
0answers
22 views

Master-master replication, is it viable? [on hold]

I'm trying to think of an architecture for my game server. Here is how it would work for two regions: A server instance runs on one machine For each machine there is a slave database to speed up SQL ...
0
votes
2answers
17 views

Use of Non clustered Indexes

I know the differences between clustered and non-clustered indexes. Can someone tell me the various scenarios where we actually prefer non clustered index over a clustered index ?
1
vote
1answer
43 views

Subtract TotalExpense from BudgetAmount In Budget Table for a specific date

I have a Budget table which has the following columns: BudgetId, BudgetDate, BudgetAmount and a table Expense which has the following columns: ExpenseID, Date, ExDescrip, Category_fk, ExAMount ...
2
votes
1answer
11 views

System Database Migration and Security - Log Shipping or DB Mirroring

I've setup log shipping between two servers (they used to be mirrored). What is the simplest or most efficient way to mirror the system databases between the primary and secondary? Is it just a ...
1
vote
0answers
20 views

Open source & cheap 'data at rest' encryption solutions

So I am exploring some options about database encryption. The best options are commercial (TDE). I am looking for an open-source implementation. Recent releases of MySQL and MariaDB have data-at-rest ...
0
votes
0answers
28 views

Is there a way to prevent an key from ever being changed or dropped?

I worked with a dev once that loved to do this. Every so often he would de-fragment the primary key so that there was no gaps, I think he was a little too OCD. I need to map Microsoft SQL rows to ...
1
vote
0answers
20 views

Remove result set doesnt meet criteria

this is part of a query result : I'm going to add a constrain to my query to remove the orders that doesnt have an invoice_type = final ,so first three rows should be removed and the second three ...
0
votes
0answers
8 views

Sharing Front-End Access Database

I have an Access back-end database with tables, queries, reports...and I have an Access front-end database with a data-entry form that will be used by 3 users. Both back- and front-ends are in same ...
1
vote
1answer
54 views

Database design for an exam

I am designing database for an exam, and I am stuck. I do not know how to do it. Here is the relevant information: Student answers 10 questions. Each question has 3 answers. Only one answer is ...
1
vote
1answer
19 views

SQL Server could not find a login matching the name provided

I have SQL Serer 2012 up and running. I created a new login (SQL Server authentication with password expiration, requires change, etc. turned off). I can start SQL Server Management Studio as the ...
1
vote
1answer
14 views

Group by multiple column acquired from join

this is part of a query result : all three columns are user_ids acquired from multiple tables join . as you see each row has only one user_id and two other user_ids are necessarily null . I'm ...
1
vote
1answer
25 views

Simple Database Design - Many to many? - First database (newbie)

This is my first database I am designing. However I am getting confused on the many to many relationships. I have a products table, each product can have inventories in many different warehouses. So ...
1
vote
1answer
13 views

What PUBLIC access means on tables in Oracle?

I recieved a communication from my DBA that they want to revoke PUBLIC access and they shared attached screenshot. What does this mean by PUBLIC access on these tables? And what happen if they "Revoke"...
2
votes
1answer
39 views

How to UPDATE by COUNT from JOINed tables

I have a schema as CREATE TABLE companies ( company_id int(11) NOT NULL AUTO_INCREMENT, company varchar(255), projects int(11), PRIMARY KEY(company_id) ) ENGINE=InnoDB CREATE TABLE employees ( ...
1
vote
0answers
10 views

Mysql multisource replication : on slave map masters dbname to something like mastername-originaldbname

I need to implement a mysql multisource replication using mysql >=5.7.11, there are already a certain number of mysql servers running which will become masters for the single slave which is going to ...
1
vote
0answers
29 views

Sql - sort according to other PK column

I Have this table : table : [SheetGroupRank] ------------------------- | Sheet_ID | int | | Group_ID | int | | Rank | int | ------------------------- Sheet_ID and Group_ID ...
2
votes
3answers
152 views

Database architecture

I am in the early stages of designing a database, and I have little (none) database design/planning experience. The database is part of a job tracking engine.. As jobs are created, they are assigned ...
1
vote
0answers
13 views

What are all the catalogs that RDBMS have to implement to be ANSI compliant?

My goal is to be able to go into any environment, and immediately get a general idea of what is going on in a database server. I know most RDBMS implement INFORMATION_SCHEMA, which has a lot of useful ...
0
votes
0answers
18 views

Stored procedure generating dynamic SQL is slow for some paramaeters

I'm having issue with a stored procedure that generates dynamic SQL, it performs ok for some parameters but very slow for some parameters. This has been an issue everyday and we are making some ...
2
votes
2answers
40 views

Efficient schema to handle time interval queries on a huge table?

We have huge table (+10 millions rows) where we aggregate the values by a using a time interval search on a Datetime column. And right now, to build single page on our app, we are querying this table ...

15 30 50 per page