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

Cannot use "ON CONFLICT" with postgres updatable view and partial index

I have an updatable view pointing to an underlying table that has a partial index. It looks something like thisCREATE TABLE if not exists foo ( ...

Asked on 10/28/2021

1 answer

What is the maximum latency / distance mysql replication can tolerate without having errors or wrong data?

I have two machines in a master - slave replication. I want to know if they are in two seperate places e.g. London, England and Tokyo, Japan are there going...

Asked on 10/28/2021 by Malazzar

2 answer

RDS MSSQL in-place upgrade how to update master db compatibility level when rdsa account is db owner

BackgroundMy workplace infrastructure team ran a typical in-place upgrade of an RDS MSSQL instance to update the version from 2012 to 2017.After the upgrade, while logged in as the "master...

Asked on 10/28/2021 by dev_etter

0 answer

How to get non-overlapping distinct intervals from a PostgreSQL table?

Using postgresql 9.6. The table has user sessions and I need distinct non overlapping sessions printed.CREATE TABLE SESSIONS( ...

Asked on 10/28/2021

2 answer

Find friends of friends (recursively) efficiently using Postgresql

Objective: Users submit their Contact Books, and then the application looks for connections between users, according to their Phone Number. Something like "6 Handshakes" idea (https://en.wikipedia.org/wiki/Six_degrees_of_separation). Problem:...

Asked on 10/28/2021 by Viktor Vsk

1 answer

SQL Server setting up logins for backup site

I am setting up a second SQL Server for a backup site.I am using SSIS to transfer user logins from production to site2. I was wondering whether I should...

Asked on 10/28/2021 by user1430949

1 answer

Group by time interval and output the source and destination station_id and count

I am stuck with a query:CREATE TABLE public.bulk_sample ( serial_number character varying(255), validation_date timestamp, -- timestamp of entry and exit ...

Asked on 10/28/2021 by Deepan Kaviarasu

2 answer

Diagnose slow script executions on specific server

I work with an unmanaged server in a remote datacenter to host web based applications. When we run the SQL scripts to create and populate an application database the whole...

Asked on 10/28/2021 by Álvaro González

2 answer

Mysql How to update n rows using count function?

In the following table, I want to set delete = true if the total records for same orgid exceed 500and I want to do it according to createdate such...

Asked on 10/28/2021 by Fakipo

1 answer

User on SQLAgentOperatorRole unable to edit jobs

My Active Directory account is on an AD group that is on msdb's SQLAgentOperatorRole. I'm able to list existing MSSQL Agent jobs, but I can only view their steps and...

Asked on 10/28/2021 by Hikari

1 answer

Ask a Question

Get help from others!

Database Administrators : Recent Questions and Answers (Page 22)

Ask a Question