0
votes
0answers
8 views

Track updated columns postgresql trigger?

I am using postgreSQL and I have tables on which I use triggers to get notified of changes on tables. Now, I have a usecase where when an update on a table is done, I want to notify only the updated ...
0
votes
2answers
18 views

Index for column with two possible value

I use PostgreSQL 9.4. I have a database where a table have index in column which can contains two possible value only(gender: male/female). When I execute a query with condition on this column index ...
1
vote
1answer
19 views

Howto query all files, their fill level and additional drive info with one query?

I need a query that puts together the following results: one row per databse file across all databases additional columns with information about the locigal drive the file is on information about ...
0
votes
0answers
4 views

MariaDB - cannot set max_connections and wait_timeout through my.cnf

I am struggling to set max_connections and wait_timeout parameters in /etc/my.cnf but MariaDB does not seem to read the parameters from the file (it reads some of the others, I haven't checked all). ...
0
votes
0answers
6 views

Oracle E-Business Suite Installation

What should i do to download latest Oracle EBS ? I mean, There are lots options on eDelivery and i confused a lot. Oracle E-Business Suite 12.2.5.0.0 for Linux x86-64, 113 files Select Alternate ...
0
votes
1answer
24 views

SQL server auto update column

I am trying to change the value of defaults column from Y to N if a new value is inserted. The default column is now only restricted to have only 1 Y based on the different membershipType. The ...
1
vote
1answer
16 views

Query: How to join on different tables depending on the filled column?

I'm pretty new to the field of SQL, but already solved a lot of problems, so until now i am familiar with the different possibilites of JOIN(s) (explicit and implicit syntax), group by, distinct and ...
0
votes
0answers
5 views

1K unused pages in each InnoDB buffer pool instance

I have configured a InnoDB buffer pool of 12 Gb, split into a dozen instances 1 Gb each. The buffer pool hit rate is 1000 / 1000, therefore so far it's looking good. Looking at the stats of the ...
0
votes
0answers
4 views

Is it mandate to turn off huge pages in Mysql 5.6

Folks, Is it required to turn off huge pages in Mysql 5.6 server under /sys/kernel/mm/transparent_hugepage/enabled -> To never? We have a heavy transactional database and calling the data segments ...
0
votes
1answer
11 views

Postgres Error: could not read block 167593 in file… SQL state: XX001

When creating a new column on a table, I'm getting the following error: ERROR: could not read block 167593 in file "pg_tblspc/16384/PG_9.4_201409291/16386/157223695.1": read only 0 of 8192 bytes SQL ...
1
vote
1answer
17 views

Data transferring

is there any practices to transfer data from two databases that have different structure of table for example old system : table [folder] with col: FolderId, name, age, sexe, date, orders New system ...
4
votes
3answers
97 views

Why set Auto Update Statistics to False?

I've just inherited about 20 instances of SQL Server, as part of a wider acquisition project. I'm in the process of assessing performance and I don't like the way maintenance plans have been ...
0
votes
0answers
23 views

Which NoSQL Database is best suited?

I have been reading a lot of blogs trying to determine which NoSQL database would be best. I am looking at moving from file based (xml) storage to using a database. The application will be storing ...
0
votes
0answers
8 views

Mysql 5.5 improvements for MyISAM?

What new improvements MySQL 5.5 announce for MyISAM as compare to MySQL 5.1. or is there any change in 5.5 for MyISAM
0
votes
0answers
11 views

Mongodb database design

I'm planning to implement this schema in Mongodb, I have been doing some readings about schema design, and the notion was whenever you structure your data like a relational database you must be doing ...
-2
votes
1answer
9 views

Fetch data from three tables two tables have one same column

I have three tables a,b,c table a sender status type name1 approved one name1 approved one name1 approved two name2 pending one table b sender p_id name1 ...
0
votes
0answers
33 views

CTE query or sql query

I have two tables Table1 and Table2 Table1 Schema: Product | company | Demand...the demand is not present in table1. Table2 Schema: demand | company which contains demand ..... I need to update ...
-2
votes
1answer
32 views

SQL server automatically update table column

The default column is now only restricted to having only 1 Y based on the membershipType column. Now, i am trying to set my defaults column able to automatically change to N if there is existing Y. ...
0
votes
0answers
4 views

pgpool: buffer overflow detected

My pgpool(use docker create) met this buffer overflow detected : And It generate many core file in server which is very big (about 6MB) Why would this happened? I try google it ,but there is seldom ...
0
votes
1answer
9 views

MySql: Migration from 5.1 to 5.5

What are pros and cons of migration from mysql 5.1 to 5.5 (MyISAM)? I am working with 500 million records, It can be very costly if it slows down. Are there any recommend settings?
-1
votes
0answers
11 views

SQL DB - Login ID inserted in audits [on hold]

SQL DB - Auditors got my login ID for executing few commands in DB server, but i haven't run any such. Please help to check ways to figure the root cause
0
votes
1answer
27 views

How to get the Sum of all column values in the last row of a resultset without using UNION?

I need to get the sum of all column values of a result set in the last row. Here is my SQL query. SELECT CS_YEAR AS YEAR, CS_MNTH AS MONTH, CS_WK AS WEEK_NO, 'Total' AS ...
0
votes
0answers
28 views

How to schedule the daily backup of a specific database in PostgreSQL?

I have a database 'ahrims', I want to schedule PostgreSQL under linux to backup this specific database (not all databases) at 4:00 PM daily. How can I achieve this? Please help!
0
votes
0answers
9 views

SSIS package for Table copy dynamically

I wants to copy a table structure along with data dynamically using SSIS 2012 from a DB server to another DB server. The server and database exist physically. The user would provide 5 parameters. ...
-1
votes
0answers
8 views

Can we have more passive nodes in a multi-clusterd nodes

How many passive Nodes can we have in a five nodes clustering? Any ideas please?
1
vote
2answers
33 views

How to find values from one table missing in another?

I am a Junior Developer. I have been asked to create a subquery to solve this problem. If the question is not clear please let me know so I can provide more details. I have two tables - Article and ...
1
vote
0answers
17 views

Find who started SQL Server Service

I found a situation where it would be useful to know who started SQL Server Service. First we did not know why it was stopped, it was not that urgent since this was a TEST instance but suddenly one ...
1
vote
1answer
18 views

how do I change regexp_substr(to_char(bar), '^.*?$', 1, 1, 'm') to only read 132 characters each time

how do I change the query below so it only reads and displays 132 characters each line with w(id, line#, line, rest) as ( select id, 1, regexp_substr(to_char(bar), '^.*?$', 1, 1, 'm'), ...
0
votes
1answer
13 views

How do you normalize a table that is indirectly dependent on a has-many relationship?

I currently have the following database design: Product: contains various description attributes Belongs to many ProductSets ProductSet: Has many Products Belongs to many Stores Store: Has ...
2
votes
1answer
9 views

Run Built-In Function on linked server

We have two SQL 2014 servers, and I have created a Linked Server on one of them to the other. As part of a task I'm trying to run I need to convert a SQL UserID to a username on both the local and the ...
0
votes
0answers
10 views

Is it a sign that oracle `TNSListener` has been started?

I am trying to do ETL from oracle to Hadoop using Sqoop. I have checked the IP and the ports. All ports are good. But I still get ERROR that shows "The Network Adapter could not establish the ...
5
votes
1answer
379 views

Do databases make a delete and an insert when having to update rows?

So today a professor told us that when the database has to make an update, internally (at low level) it makes a delete and then an insert with the updated fields. He then said that this is something ...
0
votes
0answers
6 views

extract values from different stored procedures and create one report

At the company I work, the third party taking care of the database. So there are bunch of crazy stored procedures that runs by UI tool, called IMS. The way management building desirable report is - ...
1
vote
0answers
9 views

How to set ENVREFERENCE when creating a SQL Server job

SQL Server 2014 (if it matters) When I am migrating SSIS packages and jobs between environments, I need to update the /ENVREFERENCE parameter to the command for each job step. Is there anyway to ...
0
votes
0answers
5 views

Completely reset innodb logs and files

So long story short, we've been dealing with a corrupt innodb installation on a MariaDB 10.0 server after a power outage, specifically a log in the future error. Rather than try and fake the log ...
0
votes
1answer
23 views

Slow search by LIKE and other values (1 million rows+)

I'm currently developing a kind of search website where one can search for business companies in my country. The database table has 1 million rows and quite a few colums (42 columns). But I find it ...
0
votes
2answers
10 views

Postgres Update Limit

I'm curious if Postgres has anything in place where I could limit the amount of rows kept for a ID. For example, say I have a users table and login_coordinates table. Every time the user logs in, ...
0
votes
1answer
22 views

Best database system to store and compare date ranges [on hold]

currently I´m working on a project which is dealing with a lot of date ranges. I´m starting completely from scratch, there is no existing code, infrastructure or database. Therefore I´m searching for ...
1
vote
1answer
19 views

Question about cost optimization formula for SELECT

I am a student in computer science and I have a question, which refers to cost optimization. I have to read the book (Fundamentals of Database Systems from Elmasry and Navathe) and try to present the ...
-1
votes
3answers
34 views

Exclude databases from automatic full backup

I have 10 databases on my SQL Server. We do an Automatic Full Backup every day at 00.00. The issue is there are two databases out of the 10 that should not be backed up as these databases are ...
-3
votes
0answers
9 views

MySQL database innodb tables

I cannot repair table as it is throwing message - The storage engine for the table doesn't support repair. How to solve it? Also how I can optimize mysql database?
0
votes
0answers
17 views

Is there a way to reference a column dynamically within a trigger?

I asked a similar question a few months back and I'm improving upon my solution! I have an Oracle database where I would like to trigger a procedure to do additional work on a column upon updating of ...
0
votes
0answers
9 views

Help with logic with cursor

I have a table called chapter, that houses the content for a web ebook. (There are other tables, but this is where the content is contained.) Fields are eid (PK), etype, paragraph_no, content, chid, ...
0
votes
0answers
6 views

mongod crashes with “Invariant failure getExtent( a )->xprev.isNull()” message

I am trying to start a mongodb server with the database, that is located on portable drive. I know barely nothing about the internals of this particular database. There are 647 database.N files, 2G ...
0
votes
0answers
18 views

Create a not unique FK in MySQL Workbench

I'm trying to model a database using MySQL Workbench (version 6.3.6, 64 bits, using linux mint). After syncing my model with a MariaDB (running in localhost, version 10.0.25), I discovered that the ...
1
vote
3answers
57 views

T-SQL for Query that can be done in SQL. What do they want?

We are given tables Vendors(VendorId, VendorName, ..) , Invoices(InvoiceId, VendorId...) I am going over a book exercise that asks for a T-SQL statement to find all vendors with at least one invoice. ...
2
votes
0answers
33 views

When do you know that you've made a design flaw in a SQL/relational database?

I've been working with a a relational model for a work project over the last few months, and I've gotten to the point where I'm wondering if I've made a mistake in my model's design or implemented ...
3
votes
1answer
38 views

Queries without Good Enough Plan Found

I have a SQL Server 2012 database. I noticed value of Reason for early termination of statement optimization for some queries and all gave Good Enough Plan Found. Now my questions are: What are all ...
9
votes
7answers
1k views

T-SQL : Is string a Palindrome?

I am a beginner in T-SQL. I want to decided whether an input string is a palindrome, with output =0 if it is not , output =1 if it is. I am still figuring out the syntax. I am not even getting an ...
0
votes
2answers
20 views

Complex MySQL query through relational tables

I am generating a query that returns a set of profiles that meet all the conditions posted below I am receiving the data like so in Ruby, then making a dynamic MySQL query based on the contents - ...

15 30 50 per page