Useful tips for everyday
Is it better to separate a big query into multiple smaller query? In these cases, you can indeed get faster results breaking one extremely complex…
How do I get the difference in days in PostgreSQL? In PostgreSQL, if you subtract one datetime value (TIMESTAMP, DATE or TIME data type) from…
How do I read a redo log in Oracle? LogMiner retrieves information from those redo log files and returns it through the V$LOGMNR_CONTENTS view. You…
What is clustered and non-clustered index Oracle? KEY DIFFERENCE Cluster index is a type of index that sorts the data rows in the table on…
How do I grant a database link in Oracle? To create a private database link, you must have the CREATE DATABASE LINK system privilege. To…
What is the size of MongoDB database? BSON Documents The maximum BSON document size is 16 megabytes. The maximum document size helps ensure that a…
How do I find previous values in tableau? (To show previous values, just use the LOOKUP function with an offset of -1. That does the…
How do I query a SQL transaction log? View Log Files In Object Explorer, expand Management. Do either of the following: Right-click SQL Server Logs,…
When do I add gtids to MySQL GTID executed variable? When the server starts, @@global.gtid_executed is initialized to the union of the following two sets:…
Where should you click to print the query result? To print query results on your default printer: Select Reporting Tools > Query > Query Manager.…