Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
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 answerI 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 answerBackgroundMy 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 answerUsing 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 answerObjective: 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 answerI 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 answerI 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 answerI 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 answerIn 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 answerMy 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 answerGet help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP