Useful tips for everyday
What is the use of composite index in Oracle? Composite Indexes A composite index, also called a concatenated index, is an index on multiple columns…
How can improve query performance in SQL Server? 25 tips to Improve SQL Query Performance Use EXISTS instead of IN to check existence of data.…
Do you have to be UTF-8 aware for MySQL? at this point your MySQL client and server should be in UTF-8 (see my.cnf ). remember…
Which constraint can be enforced only one per table? PRIMARY KEY constraint PRIMARY KEY constraint differs from the UNIQUE constraint in that; you can create…
Can you limit access to only one table in SQL Server? I think the answer is no but I’m looking to give someone access to…
How do you find the distinct combination? 4 Answers. Simply use the DISTINCT keyword: SELECT DISTINCT Latitude, Longitude FROM Coordinates; This will return values where…
How to resolve fatal : no pg _ hba.conf entry for host? In order to resolve this error, follow these steps: 1. Log in to…
How is data distributed in a MongoDB cluster? MongoDB partitions data in a sharded collection into ranges based on the values of the shard key.…
What is ETL and when should it be used? ETL is used to migrate data from one database to another, and is often the specific…
How do you troubleshoot a cluster issue? How to Troubleshoot Create Cluster Failures Step 1: Run the Cluster Validation Tool. Step 2: Analyze the CreateCluster…