Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
I am reading to all tutorials/books that when running SHOW ENGINE INNODB STATUS the Per second averages calculated from the last X sec, the X should be 20 to 30...
Asked on 11/28/2021 by Antonios
1 answerI'm a DB Developer and in my company we're only able to interact with hive through a technical user who owns the specific write permissions for Hive on HDFS.So...
Asked on 11/28/2021 by Mayak
1 answerI am working on making a database that queries the daily balance of a stock portfolio. The balance would be calculated as (sharesA x priceA)+(sharesB x priceB), etc. for each...
Asked on 11/28/2021 by danields
1 answerI was able to add the dbcreator server role to a user of a SQL Server DB, thanks to this nice question/answer: create-database-permission How can I REMOVE that permission?...
Asked on 11/28/2021 by Andrea Antonangeli
2 answertwo method compared1. use test; create table t (a int);2. create table test.t1(a int); my result is the first one can log the binlog but the second one...
Asked on 11/25/2021 by LawrenceLi
1 answerWe are trying to implement DR setup for our mongodb replica set and currently three nodes in DR are configured to run as hidden nodes. We are trying to test...
Asked on 11/25/2021 by Sweeti Bharti
2 answerI'm trying to write a query that get's all users that belong to Group A, but excludes users that belong Groups B, C & D. Users can belong to multiple...
Asked on 11/25/2021 by Dangerman1988
1 answerI have two tables and wanted to conditionally query one of the tables.For example below are the two tables with few matching columns in two tablesTable A(SNO, Number,Name...)...
Asked on 11/25/2021
1 answerI am creating a project with lots of tables like one for taxes, one for employees, customers etc. So how should I go about it?For eg: building the ER...
Asked on 11/25/2021
1 answermigrating from Netezza to DB2 we face the following problem: CREATE OR REPLACE PROCEDURE DoStuff() BEGIN DECLARE vStarttime TIMESTAMP; SET vStarttime =...
Asked on 11/23/2021 by Alexander Meyer
2 answerGet help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP