Useful tips for everyday
How to fix Oracle ORA-03113 end-of-file on communication channel? The proper fix is to get rid of the recovery files. You do that using RMAN,…
What is delayed replication? Delayed replication allows specifying that a replication slave should lag behind the master by (at least) a specified amount of time…
How get data from Excel to SQL Server? Open Microsoft Excel file and go to the Data tab on the Excel Ribbon (Under menu bar).…
How do I create a join in PostgreSQL? PostgreSQL INNER JOIN First, specify columns from both tables that you want to select data in the…
What is SYSAUX table space? The SYSAUX tablespace provides storage of non-sys-related tables and indexes that traditionally were placed in the SYSTEM tablespace. For example,…
Are triggers thread safe? You can fire trigger programs in a multithreaded job. The same threadsafety restrictions apply to trigger programs as to any other…
How do you clear the cache on a PC? Android Go to Settings and choose Apps or Application Manager. Swipe to the All tab. In…
Can we have a MySQL table without primary key? Table does not have to have primary key. Much more important is to have correct indexes.…
How to break the log shipped database configuration? Break the log shipping configuration by referring to the steps described earlier in the tip. Check the…
What steps are required in the development of an ER diagram? What steps are required in the development of an ER diagram? Identify, analyze, and…