Creating a new instance using Oracle Database Cloud Service on Oracle Cloud is called database deployment. It is possible to simply create a database and …
Read More »How To Create Index in CREATE TABLE Statement in SQL Server
Before SQL Server 2014, we were able to create an index in two ways by right-clicking on SSMS and clicking new index, or using the …
Read More »How To Check Archive Log Size Generated per day in Oracle
If the Oracle database is in archive log mode, the redo logs are copied as archive files. Archive files will be transferred to the directory …
Read More »Where is MySQL Error Log File
In Mysql servers, the following methods can be used to find where the error log file is. Find where the Error Log is with SELECT …
Read More »The table ‘X’ is full error in MySQL
In MySQL NDB Cluster databases, when the data memory is full, “The table is full” error occurs in all operations in the tables. To resolve …
Read More »How to convert timestamp to datetime and datetime to timestamp in MySQL
You can use the below functions to convert the timestamp to date and date to timestamp. timestamp to date -> from_unixtime() date to timestamp -> …
Read More »UPDATE STATISTICS in SQL Server
In this article, I will explain you to how to update your statistics with the UPDATE STATISTICS command by table or database basis. I recommend …
Read More »How To Check Connected Users in MySQL
To check connected users in MySQL database and what operations are performed, we can use mysql cli or we can obtain same information through queries. …
Read More »How To Reset MySQL root Password
The MySQL root password allows the root user full access to the MySQL database. If you do not remember the root password of the mysql …
Read More »How To Backup MySQL Databases With mysqldump
Mysql database should be backed up daily or periodically. It is possible to back up regularly with a script that we will create in the …
Read More »