Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
we have a SAP instance that runs on Oracle 11.2.0.4.0 DB. Since a while full online backups are failing every time. Full online backups are scheduled in SAP tcode DB13...
Asked on 11/11/2021 by plamenbv
1 answerMySQL server (5.5) is running on aws-ec2 instance with following linux detailsNAME="Amazon Linux AMI"VERSION="2015.09"ID="amzn"ID_LIKE="rhel fedora"VERSION_ID="2015.09"PRETTY_NAME="Amazon Linux AMI 2015.09"ANSI_COLOR="0;33"CPE_NAME="cpe:/o:amazon:linux:2015.09:ga"HOME_URL="http://aws.amazon.com/amazon-linux-ami/"Since Django 2.2 doesn't support Mysql 5.5https://docs.djangoproject.com/en/2.2/ref/databases/#mysql-notes....
Asked on 11/11/2021 by Palash Jadhav
1 answerI have a table with this data:shyam banarjeerahul khannapriya kumari rohit srivastavaI just want first names, like this:shyamrahulpriyarohit...
Asked on 11/11/2021
3 answerI'm a PostgreSQL DBA learning SQL Server 2019. The setup :1 Desktop, 1 LaptopBoth running SQL Server 2019 DeveloperWindows 10 Home (nothing else, no active directory, nas, san, ...)a database...
Asked on 11/11/2021
1 answerBackground I have a database in 3 different locations with the same exact static data (nothing updates it, it was a one-time import from another system). In 2 of...
Asked on 11/11/2021 by Alf47
1 answerI have multiple SQL Server 2019 instances on the same server. I've created and exported the first instance's maintenance plan, edited its exported DTSX file to change the instance and...
Asked on 11/11/2021 by Chad Kieffer
1 answerI have a batch table, and an item table, the relationship is the batch has many items (item has a batch_id foreign key). How would I make a query that...
Asked on 11/08/2021
1 answerWe had an issue with replication, where a large (7.5 million row) update was done on a 33 million row table. Replication converted that to 7.5 million individual update...
Asked on 11/08/2021 by Derek Czarny
1 answerEdit: We found the leading cause. If you join tables with the same name but in different schemas, you can get this result. Same with joining two tables using the...
Asked on 11/08/2021 by Lenniey
1 answerIn this method, first I have to get sundays dates between two dates, in this case about 1 year. Then I go through the dates in a for loop and...
Asked on 11/08/2021 by Fabian Sierra
1 answerGet help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP