Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
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 answerI 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 answerI 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 answerUPDATE 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 answerI 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 answerI'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 answerIn 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 answerI 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 answerA 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 answerI 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 answerGet help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP