Useful tips for everyday
How do I register Oracle home in central inventory? For each Oracle home in the existing shared inventory, do the following: Detach the home from…
How can lookup transformation improve performance? To improve lookup performance for relational or flat file sources, enable lookup caching in the transformation. When you enable…
How to delete a table with a foreign key? Set the FOREIGN_KEY_CHECKS before and after your delete SQL statements. SET FOREIGN_KEY_CHECKS = 0; DELETE FROM…
How do I get the percentage of two columns in SQL? Here’s the SQL query to calculate percentage of two columns (sale, goal). You can…
How does SQL Profiler work? Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring an instance of the Database Engine…
What is the difference between Amazon Aurora and MySQL? Aurora is intended for performance with cloud servers, while MySQL is designed to run on physical…
Can I copy and paste a SQL database? Open the SQL Server Management Studio and connect to Server A. Right-click on the database and select…
Can we return multiple tables from Stored Procedure? 2 Answers. The normal way is to get all at once. just construct your SELECT ‘s and…
How do I load a CSV file into MySQL? Open table to which the data is loaded. Click Import button, choose a CSV file and…
When to use hash match vs nested loops? Hash Match – is used by optimizer when no useful indexes are available, one table is substantially…