Useful tips for everyday
How do I run a script in Oracle 11g? Answer: To execute a script file in SQLPlus, type @ and then the file name. The…
How do I restore a new SQL Server database? Procedure Log in to the computer on which you want to restore the database. Open Microsoft…
Can Redshift have multiple databases? Amazon Redshift Amazon Redshift now supports the ability to query across databases in a Redshift cluster. With cross-database queries, you…
How can GROUP BY query performance be improved? You can improve performance on some grouped joins by replacing the join with a subquery. Most DBMSs…
How do I import data into my Amazon RDS DB instance? When importing data into a MariaDB DB instance, you can use MariaDB tools such…
Can a table have multiple triggers? SQL Server allows multiple triggers on the table for the same event and there is no defined order of…
How to full DB Export / Import Tom-Oracle? On a fresh database (with sys, system, dbsnmp users.), I’m afraid that full import will add and…
What is prepared statement in PostgreSQL? A prepared statement is a server-side object that can be used to optimize performance. When the PREPARE statement is…
What is a text qualifier in CSV? A text qualifier is a character used to distinguish the point at which the contents of a text…
When to use on duplicate key update in MariaDB? This function is particularly useful for multi-rows inserts. The IGNORE and DELAYED options are ignored when…