Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
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 answerBrowsing around some sys tables, I see: sys.dm_hadr_availability_replica_cluster_nodes.group_name = sys.availability_groups.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 answerI 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 answerI 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 answerHere'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 answerI 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 lares.dk
1 answerWhat 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 answerI 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 answerIf 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 answerI 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 answerGet help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP