Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
On a mysql table with about 1.7M rows, I tried to delete duplicates posts:delete a FROM comment a INNER JOIN comment a2 WHERE a.id...
Asked on 01/02/2022
1 answerI have been iterating on an idea presented by Rob Conery in his excellent post to generate monthly reports using PostgreSQL Views. My version required the View...
Asked on 01/02/2022 by James Randall
1 answerPostgreSQL: Adding an index to a table with big amount of data causes a lag for both SELECT and INSERT operations on that table, doesn't it? While PostgreSQL does not...
Asked on 01/02/2022
1 answerI have been using mysql for the past number of years and i have always wondered? Lets say you have several tables and the tables are so interconnected, in an...
Asked on 01/02/2022 by Gandalf
0 answerThe situation: I use Service Broker to develop data push approach. Now I consider a scenario:Use separate DB ( called Broker ) which has services, queues and...
Asked on 01/02/2022
1 answerIn SQL 2017, I have a 'food' table as follows:ID item Ingredients---- ----- -----------1 item1 ...
Asked on 01/02/2022 by ATMdev
1 answerI program, administer, and support an ERP application. One of my more common tasks is to understand where data originates, finding the link between a particular report field and its...
Asked on 12/31/2021 by durette
3 answerMySQL 8.0.16, 2 simple RC transactions, each trying to insert and delete rows: CREATE TABLE test1 ( id int(11) NOT NULL...
Asked on 12/31/2021 by Triffids
1 answerI'm running Oracle on a Windows server (maybe that is why it is so buggy?). It was working fine for a bit, but lately I've been having an issue. ...
Asked on 12/31/2021 by J Brune
1 answeri'm querying a table full of vehicles, however each one of these vehicles MUST have another row within another table. This query is currently taking way too long! Do I...
Asked on 12/31/2021
4 answerGet help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP