Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
I my company we are facing performance issues on a big Sql server DB (running on Azure, total size > 150GB). We have one big table (1,5GB, 3 millions records)...
Asked on 10/28/2021
0 answerI'm new to replication, as I've been mostly an old school ETL type person.I have a SQL SERVER database that runs a front end web presence. There's alot...
Asked on 10/28/2021
1 answerI'm trying to add the pgAudit extension to register the events of my database. I downloaded pgAudit and installed via git.git clone https://github.com/pgaudit/pgaudit.gitcd pgauditgit checkout REL_11_STABLEgmake install USE_PGXS=1 And...
Asked on 10/28/2021 by Ivanovich
2 answerI'm running Neo4j v4.x on an Azure VM (Linux Ubunto 16.04). Everything was running fine until my project required a resizing for more storage. This seemingly went well as I...
Asked on 10/28/2021 by David A Stumpf
1 answerI have a table named data with a column pid & display_data.Pid is the serial number of all rows. The value of display_data column is as below : For...
Asked on 10/28/2021 by Velocity
1 answerThis question is about possible approaches for time stamping every column of every row in a table. I have a table with a small number of rows (fewer than 200...
Asked on 10/28/2021 by pbarney
1 answerWe have a "database" that stores historical data in what could effectively be called a highly compressed proprietary "flat file" format. Typically these are accessed and queried using some...
Asked on 10/28/2021 by xirt
1 answerI am trying to restore a MySQL dump of size around 18GB to another MySQL server, which is running inside a container using this command:mysql -h example.com -u user...
Asked on 10/28/2021
1 answerWe're considering different approaches to save records' history in an application. Some of the managers in charge are concerned that as this is a relatively new feature of SQL server,...
Asked on 10/28/2021 by Oren A
2 answerI have a Stored Procedure which gets 6 input queries and the inputs are the same as where clause of a query. For instance where x=1 and z=5 and e=4....
Asked on 10/28/2021
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