1. All Categories
  2. Database Administrators

Database Administrators : Recent Questions and Answers

Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.

SHOW INNODB STATUS averages calculated

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 answer

IDE Access to Hive without user password?

I'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 answer

Daily Value of Stock Portfolio Postgres

I 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 answer

How to remove dbcreator server role?

I 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 answer

why binlog doesn't log the DML statement?

two 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 answer

How to promote hidden mongo node to primary?

We 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 answer

SQL Get Users By One Group But Exclude Others

I'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 answer

Oracle Select Query based on a column value

I 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 answer

Mysql : what are the steps for creating a database schema for a big project with many tables?

I 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 answer

DB2 - Using stored procedure variable in a "CREATE TABLE as (..)" Statement

migrating 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 answer

Ask a Question

Get help from others!

© 2021 All rights reserved.