TransWikia.com
  1. All Categories
  2. Database Administrators

Database Administrators : Recent Questions and Answers (Page 4)

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

Postgres sometimes uses sequential scan instead of an index only scan for data that doesn't exist

We are using Postgres 12 and We have a simple table like this:> d live_event_segmentation ...

Asked on 12/28/2021 by Strahinja Kustudic

1 answer

Can somebody please tell what is the difference between these two date comparisons?

So I have 2 queries as follows:f.DATE >= (GETDATE() - 3)f.DATE >= CAST(CONVERT(VARCHAR(10),GETDATE() - 3,101) AS DATETIME)I think they are the same but the second one gives me more...

Asked on 12/28/2021 by mameo

2 answer

Solutions to RLS (Row Level Security) in PostgreSQL for Desktop Application?

The Situation:I have a desktop application that currently uses a database which is stored locally on the computer that is running the application, and I am starting to implement a...

Asked on 12/28/2021

1 answer

Unable to grant privileges with admin account

I'm running MariaDB version 10.4.8 on Amazon RDS. Once the server is up and running, I need to create some databases, users and grant privileges to those users. Creating the...

Asked on 12/28/2021 by Prdufresne

0 answer

Is my connection using SSL or not?

I have two MySQL 5.7 databases ([db1] 5.7.27 and [db2] 5.7.29) (n.b. db1 is Linux, db2 is Windows) I have created a basic user on db1:CREATE USER 'ssltest'@'%' IDENTIFIED...

Asked on 12/28/2021 by IGGt

0 answer

Display user-defined types and their details

I've created a few new UDTs in PostgreSQL. However, now I have two problems: how to see which UDTs have been defined?how to see the columns defined within these UDTs?Unfortunately,...

Asked on 12/26/2021

6 answer

Concerns regarding changing virtual NIC on SQL Server 2008 R2 / Windows Server 2008 R2

I have SQL Server 2008 R2 running on Windows Server 2008 R2 in a virtual environment (ESXI 5.5). Client has been advised to switch the existing E1000 adapter with a...

Asked on 12/26/2021 by user77410

2 answer

mongodump: fact.bson: input/output error

We are trying to export 1.5TB database into mongodb. But its fail after 100gb and giving us below error. As we notice root mount point got 100% space. We are...

Asked on 12/26/2021 by Irfi

1 answer

InnoDB ibdata1 corrupted, innodb_force_recover not working

I think I have checked every post in the internet.Thing is my MySQL (MariaDB) won't come up and after much testing I have seen it is because of the...

Asked on 12/26/2021 by Arnau EC

1 answer

I am trying to achieve a Disaster recovery for Mongo DB

Right now i have a MongoDb HA in site one and i need another site with asynchronous replication enables in another location.This is a base plan of mine to achieve...

Asked on 12/26/2021 by linn zacharias

2 answer

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP