Useful tips for everyday
How to setup MySQL master master replication? In this post, I demonstrate how to setup mysql master master replication. In a multi master mysql configuration,…
Can a weak entity have a relationship with a strong entity? A strong entity will always have a primary key. Strong entities are represented by…
Why do you need replication in PostgreSQL multiple slave? Replication lets you perform analyses without affecting the operations of the master. You can use replication…
How do I optimize a SQL join? It’s vital you optimize your queries for minimum impact on database performance. Define business requirements first. SELECT fields…
How do I run a SQL script from Sqlplus command-line in Windows? To run a script as you start SQL*Plus, use one of the following…
Can a MERGE statement update the same row more than once? If there are two WHEN MATCHED clauses, then one must specify an UPDATE action…
What are the performance tuning techniques in Oracle? Prioritized Tuning Steps Step 1: Tune the Business Rules. Step 2: Tune the Data Design. Step 3:…
What are query details? A query is a request for data or information from a database table or combination of tables. This data may be…
Can a MySQL user change their own password? All users can change their own password. Users with UPDATE on mysql database can update passwords for…
How do I run update statistics? Right-click on the Maintenance Plans and go to Maintenance Plan Wizard. Select the Update Statistics maintenance task from the…