Database Administrators Questions, Problems & Solutions : TransWikia.com ~ Page 23

Sql server partitioned table: what happens when an update of a record changes the destination partition?

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 answer

What type of replication do I need to push webdata to offline database for analytics?

I'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 answer

Problems loading pgAudit library on Postgres 12.2

I'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 answer

How to start Neo4j on Azure

I'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 answer

Convert column value stripping html tags into sql view with rows and columns

I 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 answer

MySQL Best approach for recording last update timestamp for every column and every row

This 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 answer

Providing SQL access to flat file (proprietary) database

We 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 answer

Restore MySQL dump to a container fails with ERROR 1114 "The table is full"

I 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 answer

Are SQL Server's temporal tables here to stay?

We'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 answer

Raise application error in a stored procedure when inputs contain keywords like 'delete' , 'insert','update'

I 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 answer

Ask a Question

Get help from others!

Database Administrators : Recent Questions and Answers (Page 23)

Ask a Question