Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
I'm doing a server migration, and i'm looking at ways to speed up restore. I have a 1TB full backup file which takes about 2 hours to restoreRESTORE DATABASE...
Asked on 02/04/2021
1 answerI have a remote SQL Server: myremotedb.myremotedomain.gbl. I could connect to it from another server myserver.myareadomain (not in the same domain) using SQL Server Management Studio without problem. But I...
Asked on 02/03/2021 by Leona
2 answerI am working on an amazon RDS postgresql database where I know there had been some issue with the public schema (maybe it was dropped). But apparently the schema exists,...
Asked on 02/02/2021 by Emanuele Paolini
3 answerI have the following question regarding the allocation of disks or LUNs to ASM in Oracle, specifically, I have an Oracle 18c DB in Cluster and I have created several...
Asked on 01/31/2021 by miguel ramires
1 answerI've got a table like:╔═══╦════════════════════╦═════════════╗║ID ║ type (enum) ║ updated_at ║╠═══╬════════════════════╬═════════════╣║ 1 ║ friend_request ║ <date_time> ║║...
Asked on 01/30/2021 by Milkncookiez
1 answerI have an insane usage of cpu mysqld +600% here is the file my cnf# Example MySQL config file for medium systems.## This is for a system with little...
Asked on 01/30/2021 by Alfredo
1 answerI'm looking to import a folder of over 100+ csv files into one table on PostgreSQL using pgadmin. I have the following script but is there a way to change...
Asked on 01/29/2021 by Chris Jenner
2 answerI have a server with 64GB RAM and 64 GB swap.It's running MySQL 8.0.19 and few php scripts. Here is my config:innodb_buffer_pool_size=40Ginnodb_buffer_pool_instances=4innodb_buffer_pool_chunk_size=10Gsync_binlog=0innodb_log_file_size=1Ginnodb_ft_result_cache_limit=4000000000max_heap_table_size=4Gtmp_table_size=4Ginnodb_online_alter_log_max_size=512Mrange_optimizer_max_mem_size=0performance_schema="OFF"This server is used for heavy calculations,...
Asked on 01/28/2021 by Stalinko
2 answerHere is my issue, Source DB is Azure MSSQL - I have a table that lists all the subscriptions sold. The Relevant columns are: Account Number, Subscription Group, Purchase Date,...
Asked on 01/28/2021 by TheDemonLord
1 answerOkay, so all I'm trying to do here is "list" the managers who supervised the employee that charged a customer $100 for a rental on November 1st, 1998. My...
Asked on 01/26/2021 by elephantCoder
1 answerGet help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP