Database Administrators Questions, Problems & Solutions : TransWikia.com ~ Page 37

How to insert several csv files into Elasticsearch?

I have several csv files on university courses that all seem linked by an ID, that you can find here, and I wondered how to put them...

Asked on 12/19/2020 by Revolucion for Monica

1 answer

passing variable values to procedure in postgresql via psql

basically I have written a code to pass variable values via psql to my procedure is it supported?and if supported any pointers to get it done : my code...

Asked on 12/19/2020 by Aditya Bhardwaj

1 answer

Upgrade with DistributedAG vs adding a node with SQL Server 2019

We would like to migrate from SQL Server 2016 to SQL Server 2019. The databases are part of an Availability Group. I added a new replica using SQL...

Asked on 12/19/2020

1 answer

PostgreSQL: interpolate missing value

I have a table in PostgreSQL with a timestamp and a value.I would like to interpolate the missing values under "lat". The value under "lat" are tidalheights above a...

Asked on 12/17/2020 by CaptainAhab

1 answer

What could cause SQL Server to deny execution of a SP at first, but allow it later with no privileges change?

A user (Windows login) just complained he was denied the execution of a procedure. I went to check and verified he had the privileges to execute it. I didn't change...

Asked on 12/16/2020 by Ronaldo

4 answer

How can I better model the relationships in this project?

I'm developing an internal tool (as an intern). We deal with a lot of hardware, which is all custom and managers have a hard time knowing who is developing on...

Asked on 12/16/2020 by J Hache

1 answer

duplicate key error index MongoDB

I have rocket.chat server connected to LDAP.When one of users try logging to their account he get logged to someone other account, it's probably because indexes. My logs look...

Asked on 12/16/2020 by Simonell

1 answer

Mariadb master master replication supported by HAPROXY for automatic failover

We have implemented master-master setup in maria-db. Master A is being used for readwrite and Master B is used for backups and MIS operations. We have built this setup so...

Asked on 12/16/2020 by Gagandeep Singh

1 answer

Are snapshots generated for each sub query inside a Postgres READ_COMMITTED transaction?

From what I understand - in a READ_COMMITTED Postgres transaction “the transaction obtains a snapshot whenever an SQL command is executed” source. Does this mean a snapshot...

Asked on 12/15/2020

1 answer

Optimize table on large table online DDL Feature

I am running optimize table on MySQL table size 340GB in size and storage engine is InnoDB.mysql> show variables like '%tmp%';+----------------------------+------------------+| Variable_name ...

Asked on 12/14/2020 by Adam Mulla

1 answer

Ask a Question

Get help from others!

Database Administrators : Recent Questions and Answers (Page 37)

Ask a Question