All Questions

we are experiencing a threads running high issue mysql> show global status like '%buffer_pool%' -> ; +-----------------------------------------+--------------------------------------------------+ ...

I am trying to install Oracle database 12c on Oracle Linux 7 version. But it is keep on failing with the below error. [INS-30131] Initial setup required for the execution of installer validations ...

I have performance issues with one particulary large table, 500+ Million rows, 300Gb data, Postgres 10.5. It is already partitioned. I am working on optimising it here and there, but that is not ...

Hi I am trying to do DBA course that requires that I use Oracle database. I am using my corporate pc to do it. I set up the loopback adapter to enable localhost communication and setup the hosts ...

I'm currently working on a project integrating AD with SQL Server data, which I am handling mainly via powershell (Invoke-SQLCMD in particular). The issue I'm running into is if someone has a special ...

A few years ago I've stumbled upon a database design approach, but I can't find any information on this for the love of my life. Its main feature was normalizing tables in a way where every "property"...

is it possible to limit somehow usage of resources for pg_dump? The problem is, whole DBase is 775GB and i have two very large tables: pg_largeobject table is – 390GB pg_largeobject statistics: ...

SELECT DISTINCT d.name AS "ID:Link/Demo Request:120", d.requester_name AS "Requester Name:Data:190", d.customer_name AS "Customer Name:Data:250", d.date_of_request AS "Date Of Request:...

Like the code below is it safe to do that? create definer=`root`@`%` procedure `test`() label: begin declare exit handler for sqlexception rollback; start transaction; select condition from table ...

Why is it necessary to run both mongod and mongo.exe in windows? What's happening behind the scene? What's the difference between these two?

I have a table which contains articles on movies. Each article has a title and many of them have common phrases in them. I would like to do some analysis on the data and extract these common phrases ...

We have an application that needs access to the database all the time to work properly and we are planning on deploying SQL Server 2012 AlwaysOn Availability Groups on Windows Server 2012. We have ...

I am using some scripts from another topic, but the accepted answer isn't working for all my data scenarios. I would have asked my question on the original How to check for Non-Ascii Characters post, ...

I have a certain IDs in a table that I would like to change a column value from false to true. How can I do a loop that goes through the specific IDs given and changes a column value from false to ...

Before you write about the dangers of not having backups, etc., please withhold judgement... perhaps I just inherited the problem? I have an .mdf which which I am trying to attach to SQL Server 8. I'...

I have a few Percona 5.6.30 servers with a TokuDB table that has ~120 million rows. On some of these servers, row count in SHOW TABLE STATUS mysteriously decreases until is hits 1. This is accompanied ...

I am running master-slave replication, Can I manually move binlog files from the master server to the slave and make the slave read them locally? I am willing to do so because I am running out of ...

We're running Centos 7, we're in the process Mariadb 5.5, upgrading to 10.3 today. PHP 5. The queries are bad, and there are far too many of them to optimize, but I'm trying what I can, the database ...

I'm trying to configure SSRS to use email subscription feature. This SSRS server is hosted on AWS and I have an SMTP relay to use. This SMTP relay requires an userid and password to authenticate. I ...

i have age column in MySQL database. So my question is how can i increase the age value by 1 every time a year passed. For example this year the age value is 20 and the next year the value will be 21. ...

cat /etc/redhat-release CentOS release 6.5 (Final) thread variables join_buffer_size 4k read_buffer_size 2k read_rnd_buffer_size 4k sort_buffer_size 4k key_buffer_size 2k tmp_table_size 64M ...

I think the answer to this is an obvious yes, but I'm having trouble finding confirmation on it. All the questions related to charsets seems to be about changing the charset and not only collations. ...

I see a MongoDB service in Microsoft Azure but that deploys a VM and installs MongoDB in that. I am guessing this will not auto scale and also charge me for the entire VM and MongoDB management (not ...

I got these error messages when migrating from Oracle to MSSQL (Unfortunately, the error messages are in German languages) Verletzung der PRIMARY KEY-Einschränkung "DTR_PK". Ein doppelter Schlüssel ...

I'm trying to upgrade from 9.2 to 9.5 using the pg_upgrade tool. I'm using CentOS 7.0 current postgres bin folder: /opt/rh/postgresql92/root/usr/bin new postgres bin folder: /opt/rh/rh-postgresql95/...

I want to delete records from a table that are not found in a subquery. But it's not having the desired result. The table has multiple rows per SKU. Each price row has a valid_from and valid_to date ...

This is my first question so please bear with me ! We have an external company whose developers need to login into an instance on our on-premise SQL Server 2016. They have AD logins, and these are ...

I've setup a backup script on my Ubuntu box using mongodump. However this currently doesn't work because of an error when attempting to dump the built in config database: (Apologies for the image, I ...

I have a stored procedure that runs xp_cmdshell with a user with sysadmin right.(it was created by someone else long time ago). For security purposes I need to remove the sysadmin right from this user....

Each hotel has several room types (e.g. singles, doubles, doubles with views). For that hotel and room type, there are a certain number of rooms available and the room type has a description for that ...

I can't make out if the following is a problem or not, and what the solution might be. show processlist; +--------+------------------+-----------+-------------------+---------+------+-----------------...

I'm looking to improve overall SQL performance of a customers application. On each table of the application, there is a computed column, that uses GETUTCDATE and a combination of three columns on that ...

This is fast (49ms): v_cpf_numerico := ext.uf_converte_numerico(new.nr_cpf); select cd_cliente into v_cd_cliente from central.cliente where nr_cpf_cnpj = v_cpf_numerico; This is slow (15 seconds): ...

Example Table: Result Table: Could you please help me on this, so that I can get exact result what I'm expecting to get? Please any one of you can look into this? I'm able to get the results using ...

I've got a question about spawning stand-alone threads on Postgres. Here's what I'd ideally like: Have a postgres-side solution to automatically launch tasks on a schedule in their own threads. ...

How can I disable binary logging on MySQL 8.0? I am needing to import a large MySQLDump file, and don't want to fill the Binary logs with many GB of data. In the past I would have set log_bin=0 in ...

I have started working in a project which has a big database, around 300GB. For security reasons I can not access database from my local web app. So I need to copy last 100,000 from each table. To ...

My question is very similar to this but not the same. The table is the same: rows with ID, volume, and price. In short, I need an SQL query that will give me the rows with the lowest prices whose sum ...

If I right click a table, I get the normal designer option: But if I right click a memory optimized table, the designer is missing: The server is 2016 and I've tried it in SSMS 16, 17, and 18.3. Is ...

We have a problem with peak loading while writing data to database This is example of error SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction SQL: insert ...

MYSQL patching. I took all database backups before starting patching. If we patch mysql 5.6.30 to 5.6.32 and if we want to rollback to 5.6.30 due to some issues. Can we do that? if so should we have ...

I have a MYSQL master with two slaves also running MYSQL 5.6. I want to create another slave and that needs to be MYSQL 5.5. I was wondering if replication will work smoothly. I have ...

I have a query which is spilling to tempdb. I understand that the cardinality estimates are wrong and causing this spill. I've read few articles that mentions updating the statistics and rebuilding ...

My client’s tablespaces are autoextend off and i add monthly or bimonthly 3 or 6 gb space for tablespaces. Can you advise me if there is a recommended datafile size for Oracle 11gR2 on Windows 64 Bits?...

My change request to patch 3 SQL instances on the same server was denied because of one instance - they say a server reboot is fine, but not a few hours downtime. Seeing as each instance is ...

Which database we should choose for an application of cryptocurrency exchange system like Binance? This exchange system needs to be real-time on database changes and have to handle so many money ...

i have some gps modules that send data to my database. On update of the last package sent i want to compare new values with old values and insert into a new table only those values that are diferent. ...

I have worked on Oracle Database 18c Express Edition, while I try to export database schema by using expd command, I have an issues ORA-12954: The request exceeds the maximum allowed database size ...

In two tables I have a column called table1.column_xml and table2.column_xml_2 defined as CLOB(1000000). The fields in the column contain XML formatted information like below column_xml ...

Why would I get an 'incorrect syntax' error with this (on the OUTPUT keyword): DELETE tb FROM dbo.TransactionBatch tb OUTPUT Deleted.TransactionID INTO #TransactionIDs INNER JOIN @...