-4
votes
1answer
25 views

display the rows with both null and not null under same value [on hold]

I want to display the rows which is having same values in all columns except one with column having one value is null and another one is not null
0
votes
0answers
10 views

Order by in json field in Postgres and using django

I am using django 1.9 with Postgres 9.3. I am executing a query to search from json data, but the problem I am facing is that I can't use ORDER BY clause if I am using JSON. The json is: { ...
0
votes
1answer
14 views

need to join Vertical row as per values in Horizontal rows

TABLE 1 +----+--------+-----+ | id | userId |state| +----+--------+-----+ | 1 | 1 |AZ | | 2 | 1 |AK | | 4 | 1 |AL | | 5 | 1 |CO | | 6 | 1 |CA | | 7 | 2 ...
0
votes
0answers
11 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
24 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 ...
3
votes
1answer
29 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
1answer
19 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
9 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
52 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
23 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
6 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
13 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
30 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 ...
5
votes
3answers
330 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
28 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 ...
-4
votes
0answers
25 views

Mysql 5.5 improvements for MyISAM? [on hold]

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
15 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
11 views

Fetch data from three tables two tables have one same column [on hold]

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
40 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 ...
-3
votes
1answer
38 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
11 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 ...
-1
votes
2answers
19 views

MySql: Migration from 5.1 to 5.5 [on hold]

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
12 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
1
vote
0answers
39 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
36 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
13 views

SSIS package for Table copy dynamically [duplicate]

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
9 views

Can we have more passive nodes in a multi-clusterd nodes [on hold]

How many passive Nodes can we have in a five nodes clustering? Any ideas please?
1
vote
3answers
55 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
21 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
26 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
14 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
13 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
13 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 ...
8
votes
1answer
412 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
1answer
23 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 is giant complex stored procedure that produces the result for one parameter only. When management needs a desirable ...
1
vote
0answers
10 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
11 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
42 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 ...
3
votes
2answers
32 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, ...
1
vote
1answer
26 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 ...
3
votes
1answer
23 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
50 views

Exclude databases from automatic full backup [on hold]

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
48 views

MySQL database repair - innodb tables [on hold]

I'm using navicat premium and the UI is reporting that the database is corrupt and asking to be repaired. I have some innodb and some MyISAM tables. I did repair but issue not resolved Is there any ...
0
votes
1answer
27 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
8 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
21 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
62 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
37 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 ...

15 30 50 per page