All Questions

Filter by
Sorted by
Tagged with
1
vote
1answer
32 views

PostgreSQL Copy command internals

I need to know some internals about the copy command in PostgreSQL 10. In particular I need to know if the copy from into a remote database makes batch insertions. If so, what is the default ...
2
votes
1answer
17 views

MongoDB map-reduce impacts insert performance on source collection

I have a "hot" MongoDB(4.0.5) capped collection with a timestamp (and several other) indexes. Many applications (Java, NodeJS & C++) insert (never update) records into this collection at a rate ...
-2
votes
0answers
7 views

i have problem with mysql workbench when synchronising after creating of the table

this the error that occurs anytime i try to synchronise mysgl workbench
0
votes
0answers
17 views

unable to rename or drop table in mysql 5.7

After a power outage database is working ok. After a week, we need to rename a table, so whe open our mysql cli and issue: RENAME TABLE my_table to my_new_table; SQL Error (1050) Table '...
1
vote
0answers
26 views

Denormalize big sparse tables, RDBMS or NoSQL? [closed]

I'm seeking technical advice regarding database denormalization. Use case: We want to be able to read with low latency denormalized tables with at least hundred million rows and the same number of ...
0
votes
0answers
39 views

Performance issue when loading data in postgres RDS

Can someone please help me on the Below Issue on Postgres RDS. We have two Postgres instances in AWS RDS. When we run the Full or Incremental Data load on one instance by fetching the data from other ...
0
votes
2answers
29 views

Errors in DB2 8.0 db2diag.log

We have a very old PeopleSoft HR system running on DB2 8.x. Numerous times a day we get the following errors in the db2diag.log file. 2019-11-04-01.22.24.012784-300 E16054C794 LEVEL: Error (...
0
votes
0answers
33 views

DB2 iseries query without cache

Is it possibile to perform a query without using cached data? I need to test many similar queries and I need to compare process time. To make the measures comparable, I need to run each query without ...
0
votes
1answer
49 views

Maintaining a production big table

I have a very large table: Table1 in a production environment which I need to alter a column in. What's the best preferred way to do so without down time? Option 1: CREATE TABLE Table1_new LIKE ...
0
votes
1answer
20 views

What exactly is the use of the column USER in a pg_hba.conf file?

Let's say I have a pg_hba.conf file for my Postgresql server. I know that in order to allow other IP addresses to access my Postgresql server, I need to write their entries in my pg_hba.conf file. Now,...
1
vote
1answer
28 views

Levenshtein can't look for Russian words [on hold]

I have a script that searches the database for words using the Levenshtein distance algorithm. Everything is fine when I am searching for English words, but when I am searching for words in Russian,...
3
votes
2answers
117 views

Suppress database change message in SQLCMD.exe

I am writing a script generation script. The script is generating list of DDL statments. The util_generator.sql generation starts with database connection: USE [TARGET_DATABASE] GO ... Many queries ...
0
votes
1answer
24 views

Different ways to log in to MariaDB

I'm trying to log in to a mariaDB database which is (at least the vendor of the product that it was installed for tells so) "protected" by SSL. I tried several tools but none of them works fully. ...
-2
votes
3answers
59 views

Running Total by Computing column based on Previous value

I have requiremtent to get the result as mentioned below in sql Running Amt = Amt + Previous InterestAmt How 202.5 comes in second row for RunningAmt Previous row 100 value + current row 100 value + ...
0
votes
1answer
34 views

PostgreSQL : Prevent SQL Injection in pl/pgsql function [on hold]

I am trying to handle sql injection related to startdate and enddate in the below pl/pgsql function. Let's say If I provide startdate as '2019-10-02' and end date as the following : 2019-10-16', '...
0
votes
1answer
39 views

How to query Last inserted row for each group in oracle 10

I have two tables about users where I want to join two tables and show the latest remarks of each user bellow is table I want to query the latest remarks for each user (1 remark per user) bellow ...
0
votes
0answers
32 views

Case inside case in oracle query

Can anyone help me? I want to use query using CASE WHEN with logic where time less than 03:00 PM on Monday until Friday will get value start from tomorrow 03:00 PM until today 03:00 PM SELECT ...
3
votes
1answer
41 views

DBCC PAGE equivalent in Postgres

In SQL Server you could check specific index information using the DBCC PAGE command. Is there anything similar in postgres? And if there isn't, how would you get the same info then? This is simply ...
3
votes
2answers
52 views

Default collation not working?

I don't understand why the default collation on my psqlserver 11 instance returns a different result than using with explicit collation. Details: show LC_CTYPE; -- de-AT show LC_COLLATE; ...
0
votes
1answer
49 views

Moving Partitioning Files To Another Disk Drive In SQL Server

There is a production table which was partitioned by someone in our company. Some partitioning files was wrongly located to different disk drive. I have to move those files to the disk where they ...
0
votes
0answers
20 views

Is there a way to Automatically send reminders/alerts by mail in Excel? [closed]

I want to create an Excel dashboard that sends an email when a product is approaching expiry. Is it possible even if the workbook is off? Can MS Access do this? Thanks in advance
0
votes
0answers
13 views

Postgres Database Level Incremental Backups

I need to take database level incremental backup in postgres. I have searched on internet, however all available methods and tools provide whole database cluster level incremental backup. But, not any ...
1
vote
0answers
12 views

Sharded Azure SQL Database Split-Merge Tool

Background I am developing a multi-tenant application that supports each Tenant having its own database and/or sharing a database with other Tenants. The design is similar to this, though I doubt ...
1
vote
0answers
6 views

Date getting truncated on PDI 7.1 for salesforce DB - Need workaround

We are working on transformation which inserts date into a salesforce DB and are seeing issues. Below are the issues: A transformation working in PDI CE 6.1 do not work in CE 7.1 or CE 8.3. Error : ...
0
votes
1answer
23 views

How to ensure database is cataloged

I am planing to upgrade my database. I am referring to this website: https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.qb.upgrade.doc/doc/t0007193.html On the Before you begin ...
2
votes
1answer
15 views

multiple archive_command in PostgreSQL

I have replication with PostgreSQL, so I want to set archive_command = 'cp %p /var/lib/postgresql/11/main/archive/%f' but I also want to save WAL files to another safe place: S3. So is it possible to ...
0
votes
0answers
8 views

[Linux LEAP 15.1][mariadb 10.4.3][C API] The UTF8 characters are not handled as before (10.2.9)

This C source code extract is expected to execute a query... but even if I change the name of the table from "Localités" to "Localites", the program no longer display the utf8 characters as the ...
7
votes
1answer
468 views

Is there a reliable way to determine how long it took the optimizer to generate a query plan?

I'm not sure where I'd start, but is there a way to see how long it took the optimizer to generate a query plan for a query? Is it stored in any of the DMVs or something that's part of one of the ...
1
vote
1answer
29 views

How to restore a database with innodb tables from files?

I am trying to restore a MariaDB database containing innodb tables from files. Blue-eyed as I am, I considered this an easy task: I just stopped the server, copied the files and restarted it as ...
2
votes
3answers
28 views

Does Postgres automatically rotate WAL files out (pg_xlog) if archive_mode is off?

I'm relatively new to PostgreSQL administration and I'm attempting to pick up the nitty gritty details as I go. My question is, assuming I have no need for disaster recovery and I don't turn on ...
4
votes
2answers
28 views

Restrict Postgres superusers to local only connections

I have a database with several users: foo, bar, and super. I was looking at pg_hba.conf to lock down access. I'd like to allow foo and bar to be able to connect from any IP with password ...
1
vote
0answers
21 views

mysql - importing large Tablespace: Lost connection during query

iam trying to recover innodb table which has 1.5M rows from ibd file ( 5.5 GB ) this is the exact steps i do: getting create table query using mysqlfrm command create the table Alter Table discard ...
0
votes
1answer
28 views

why innodb generate table-lock when two sql using different index?

I know innodb-engine row lock by add lock to index item. But I don't understand the following scene. Prepare sql: DROP TABLE IF EXISTS `tbl_order`; CREATE TABLE tbl_order ( `order_id` BIGINT NOT ...
0
votes
0answers
9 views

mongo uses high cpu [closed]

0 I use replicaset mongo 3.6.3 we simulate loading and queries on mongo after the simulator finished it seems like the mongo didnt release is ram even though he dont need it? do you know how and ...
1
vote
2answers
12 views

How does autocommit=off affects bulk inserts performance in mysql using innodb?

I know that turning off autocommit can improve bulk insert performance a lot according to: Is it better to use AUTOCOMMIT = 0 And I have made experiments to confirm that conclusion. But what I want ...
0
votes
0answers
17 views

Auto Increment Field

I am trying to implement a simple table in MS - ACCESS where im using two PK's for say a WEATHER table. PK LOCATION PK ID DATE TEMPERATURE I wish to increment the id based on the location, ...
1
vote
1answer
31 views

SQL JOIN ON Issues

I am trying to use a JOIN ON statement to SELECT two columns, one with the Team_Name and the other with how many times they have won. I want to include all teams, even those who haven't won at all. ...
1
vote
0answers
9 views

What will be the behavior of mongodb under this partial network partition

Consider a shard cluster: Has only one shard, but the shard has 3 replicas A, B, C Has 3 mongos instances mongos and mongod instance are running across 3 different data centers. The primary node (A) ...
0
votes
3answers
79 views

Create stored procedure with dynamic number of columns + column names

I am relatively new to postgresql (I have version 12), and am having some trouble creating my first stored procedure. The real trouble is that I need it to be dynamic in some way, and thus I am having ...
0
votes
0answers
28 views

Why expdp does not include identified by statement?

I have the following error when I do a impdp (from a pdb in a 12c to 11g. I also used the parameter version=11.2.0) IMPDP LOG: ORA-01938: IDENTIFIED BY must be specified for CREATE USER Failing sql ...
1
vote
1answer
34 views

SQL Server Extended Events purging

How do we purge events older than a day in Extended Events in SQL Server 2012. Stopping and Starting the session is not helping. Target : asynchronous_file_target Trying to create a job which will ...
9
votes
1answer
225 views

Key-range RangeI-N lock compatibility in SQL Server

The documentation states that the RangeI-N lock (Insert range, null resource lock; used to test ranges before inserting a new key into an index) is compatible with itself (see the compatibility matrix)...
1
vote
2answers
39 views

What's difference between MySql IN and ANY operator?

Data Dump CREATE TABLE `customers` ( `customer_id` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(50) NOT NULL, `last_name` varchar(50) NOT NULL, `birth_date` date DEFAULT NULL, `...
4
votes
1answer
40 views

How can we handle out-of-range errors when aggregating data?

For example we have some data in int8 fields and want to build aggregations: e.g. the sum of squares. The result should also be int8 (not a float). So obviously calculating the sum of squares for ...
2
votes
1answer
42 views

How to insert multiple IP addresses in a pg_hba.conf file via unix shell script?

I need to write some IP addresses to the pg_hba.conf file of my Postgresql, in order to allow remote access from those IP to my machine. I have the following code in shell script to do that for a ...
1
vote
0answers
25 views

SSMS Connect to remote SQL instance with Windows Authentication

I have a remote SQL instance (Microsoft SQL Server 2016 (SP2-CU3) (KB4458871) - 13.0.5216.0 (X64) I can connect to the instance fine locally on the box through SSMS using both Windows and SQL ...
1
vote
1answer
19 views

creating a mysql.cnf file for import

I have created a config file for dumping .sql with no password prompt, is it possible to do this when using import? I have read somewhere to just add on the cnf file "mysqlimport" then the credential ...
1
vote
0answers
15 views

Can multiple process pull off the same record from an Oracle FIFO queue?

My understanding of Oracle AQ (Advanced Queuing) is that no two (or more) processes can pull off (drain/consume) the same record of an Oracle FIFO queue. Is this correct or is some code needed to ...
1
vote
0answers
59 views

Deadlock's Log in Sql Server [closed]

The following deadlock's log just confuses me. What is the difference between the "mode" in [keylock] and the "mode" in owner-list? Why owner has a requestType=wait, typically it is only seen in ...
2
votes
2answers
77 views

Cannot connect to my SQL Management studio after moving a tempDB

In quite a bad position here. This afternoon on my tempDB I ran the query: sp_helpfile to locate where my MDF and LOG file were. My MDF was on my C: drive and my LOG file was on a D: drive so I've ...

15 30 50 per page