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

Postgres normalize human name string

Is there some function to normalize name string: select normalize('R.C. Bray') 'R. C. Bray'Or the opposite direction? The simple replace('. ', '.') or replace('.', '. ') is wrong...

Asked on 12/24/2021

2 answer

Stored procedure for adding cascade

I have a DB with 180 tables, and I was doing a logical deletion, now I need to do some testing with physical deletion. Is there a way to alter...

Asked on 12/22/2021 by user73639

1 answer

Using hard-coded host name in logon trigger

I need to write a trigger which prevents certain users from logging into the production database. We use Active Data Guard. If I hardcode the Linux hostname in the trigger...

Asked on 12/22/2021

1 answer

MySQL Optimization Guidance Needed

UPDATE 6/23/2020: Haven't noticed any odd CPU spikes lately, but noticed that the MySQL memory footprint grows indefinitely until it goes OOM and is killed by the kernel. Where should...

Asked on 12/22/2021 by enyceexdanny

3 answer

MySQL subquery with WHERE filters not working as expected

I have a question/tagging system like StackExchange. I want to display the tags associated with each question and also show the total number of times the tag is used,...

Asked on 12/22/2021 by HDer

1 answer

Sybase IQ cache database result

I'm using a query that calculates some values on a table with about 11 millions rows. And I need to display the results in real time (on my site), but...

Asked on 12/21/2021 by Daria

1 answer

In what order does sqllogship.exe process groups of log files?

In what order does sqllogship.exe processes groups of log files based solely on filename order or does it does it do it based on file timestamp primary sort then filename...

Asked on 12/21/2021 by Scott Magnan

1 answer

Help Outputing MySQL General Log to Named Pipe

I have a cPanel, Centos 7 webserver using MySQL 5.6, in which I am trying to output the MySQL general log to a named pipe I have created. I have...

Asked on 12/21/2021 by WiddleWabbit

2 answer

How can I capture error thrown by SET_LOCKTIMEOUT in ola Hallengren

A stats only job for Ola Hallengren was blocked for the 180 seconds as specified below. The job threw an error and emailed me and the other DBA. ...

Asked on 12/21/2021 by Lee M

1 answer

Windows Azure Table Row Key strategy, what makes a useful RowKey?

I read somewhere that the row key should be useful - which is why auto numbers are not supported. However, for all 3 tables I've started saving I can't...

Asked on 12/19/2021 by Adam Heeg

1 answer

Ask a Question

Get help from others!

Database Administrators : Recent Questions and Answers (Page 6)

Ask a Question