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

Why does MySQL wait for a table lock for a validation query?

Why are simple validation queries waiting for a table lock?In our Hibernate setup we are using a validation query to check that a connection is still usable within the pool....

Asked on 01/10/2021

0 answer

how to update SSRS execution account automatically through power-shell?

I need to update the password for the SSRS Execution account for every 15 days. How can I automate this process using power shell or some other scripting?...

Asked on 01/10/2021 by hadrian blackwater

1 answer

SQL Server :: how to move country code column to another table?

I have 2 tables:tbl_Countries: 250 values, with columns like CountryName (Afghanistan), TwoCharCountryCode (AF), ThreeCharCountryCode (AFG).Like this:CountryName TwoCharCountryCode ThreeCharCountryCode Afghanistan AF ...

Asked on 01/09/2021 by Francesco Mantovani

1 answer

Does pg_dump flag -j give performance improvement up to -j 16 or -j 32 or even -j 64?

I am backing up and restoring a large DB (7+TB) ... I am usingpg_dump -j 8 -Fd(8 parallel dump threads with directory formatting). I just wondered if anybody has...

Asked on 01/09/2021 by Mark McWiggins

2 answer

MySQL nested groupby with count other field

I have a table like this:option question questionId A question1 1 A ...

Asked on 01/08/2021 by Jayakusumah

0 answer

How can I transpose multiple unrelated columns into rows in SQL Server?

I have a table that looks like the following:PersonId EyeColor HairColor FavoriteTVShow FavoriteMovie ...

Asked on 01/08/2021

1 answer

MySQL Query causing high CPU and taking forever to execute

this below query takes a long time to execute in excess of 120 seconds, upon checking the explain plan it seems to be using using where, using temporary; using filesort....

Asked on 01/08/2021 by pg2286

1 answer

Postgres files postgresql.conf and pg_hba.conf - which take priority?

Which of the two postgres configuration files postgresql.conf and pg_hba.conf takes priority? pg_hba.conf controls client authentication methods including 'md5' and 'scram-sha-256' postgresql.conf includes an entry for password_encryption which can be...

Asked on 01/07/2021 by ConanTheGerbil

1 answer

Drizzle database system design questions - architecture &c

Given that I have some time on my hands at the moment, I was wandering through old Drizzle database stuff - I particularly like the microkernel design principles that underlie...

Asked on 01/06/2021 by Vérace

0 answer

Update staging table records in SQL Server 2017 with INSERT trigger and table-valued function, using INSERTED records

I am loading hundreds of order files (positional flat files), via SSIS, into staging tables, and ultimately into production tables. As part of the staging table population process, I...

Asked on 01/05/2021 by Kulstad

1 answer

Ask a Question

Get help from others!

Database Administrators : Recent Questions and Answers (Page 33)

Ask a Question