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.

Automatically purging binary logs

I'm currently trying to create an scheduled event on MySQL to purge binary logs every week. The create event statement is as follows:CREATE EVENT purgebinlogsON SCHEDULE EVERY 1 WEEKSTARTS...

Asked on 01/06/2022 by kriegu

6 answer

What is the difference between sys.dm_hadr_ tables and sys.availability_groups / sys.availability_replicas?

Browsing around some sys tables, I see: sys.dm_hadr_availability_replica_cluster_nodes.group_name = and sys.dm_hadr_availability_replica_cluster_nodes.replica_server_name = sys.availability_replicas.replica_server_name and sys.dm_hadr_availability_replica_cluster_nodes.node_name = sys.availability_replicas.replica_server_name and sys.dm_hadr_database_replica_states.group_id = sys.availability_groups.group_id Could someone please clarify for me whether the...

Asked on 01/06/2022

1 answer

MongoDB 4.2 using change streams with read concern majority disabled in a PSA deployment

I currently run a PSA (Primary, Secondary, Arbiter) deployment and thous only have two databearing nodes.In case of a databearing node going down, read concern majority prevented the change...

Asked on 01/06/2022 by Franz Huebner

1 answer

Query customers attributes

I need to create a system where the user creates dynamic filters based on our customer's attributes. There are more or less 30 possible filters and 30 millions of customers,...

Asked on 01/06/2022 by Mac Portter

1 answer

MongoDB different members of cluster choosing different index

Here's behavior I can't explain at all: I have 5-replica-set sharded cluster. I have a query that on 4 of the 5 RSs, it uses one index. But on one...

Asked on 01/04/2022 by marc esher

1 answer

How to search for compound words, and get the word parts returned

I need to be able to search for compound words like "menneskerettighedsforkæmperens" (the human rights activist's) and find the words "menneske" (human), "rettighed" (right) and "forkæmper" (activist). I have all...

Asked on 01/04/2022 by

1 answer

What is the CURRENT_DATE or current date value function for SQL Server?

What is the SQL Server functionality that allows you to get the current date as a DATE type like the SQL Standard's CURRENT_DATE feature. What is the <current date value...

Asked on 01/04/2022

2 answer

macOS Catalina - postgreSQL - sysctl.conf still relevant?

I had the following settings in /etc/sysctl.conf before Catalina:# PostgreSQL Config for the MACkern.sysv.shmmax=2147483648kern.sysv.shmall=524288kern.sysv.shmmin=1kern.sysv.shmmni=32kern.sysv.shmseg=8kern.maxprocperuid=1024kern.maxproc=2048The Catalina install moved this file to the /Users/Shared folder as /etc is now considered private...

Asked on 01/04/2022 by Crashmeister

2 answer

The opposite of ordering by a column in SQL

If you have a table and you'd like to sort by a column you can use order by foo to order the results by foo. Is it possible to do...

Asked on 01/02/2022 by John Hamelink

2 answer

How to deal with a person that may have multiple alias names?

I am designing a neo4j database which will be primarily be used to store information about people. One of the requirements is that it must be able to store an...

Asked on 01/02/2022 by JavascriptLoser

2 answer

Ask a Question

Get help from others!

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