Useful tips for everyday
How to check if Trigger was fired by insert or delete? [Table1] AFTER INSERT, DELETE AS –if save –do some work –else if delete –do…
How do I change a variable in MySQL workbench? To reset a persistent global system variable, deselect the individual check box and then confirm the…
What is CPU caging? Scenarios for Server Consolidation. Instance Caging limits the amount of CPU an Oracle database instance consumes, using the. Oracle Database Resource…
What can you do to prevent database failure? How to Prevent Data Loss Due to Database Failure Backup Your Backups. First things first – don’t…
Can a server have multiple instances? You can create more than one server instance on your system. Each server instance has its own instance directory,…
How is SQL query execution time calculated? One simplistic approach to measuring the “elapsed time” between events is to just grab the current date and…
What is the purpose of Read Replicas? A read replica is a copy of the primary instance that reflects changes to the primary in almost…
Can we rename a column in the output of the SQL query? You can use a form of SQL SELECT AS to rename columns in…
How do you rename a schema in Oracle? Unfortunately, oracle don’t allow to change schema name easily. after import via data pump, the next step…
Is SQL Server Express free for commercial use? Reality: While SQL Server is a completely free product, it is also completely capable of legally being…