Useful tips for everyday
What is Gtid in Mariadb? A global transaction ID, or GTID for short, consists of three numbers separated with dashes ‘-‘. For example: 0-1-10. The…
What are incident categories? Categorization is the process of arranging incidents and problems into classes or categories. The main objective is to understand what type…
How do you SELECT a declared variable in SQL? Variables in SQL procedures are defined by using the DECLARE statement. Values can be assigned to…
Are Cross joins slow? Cross JOIN is a slow operation, but getting back 25K rows should not be too slow. A cross join of two…
How do you fix a Transaction Log for a database is full? Try one of the 4 suggestion below to fix this issue: Under SQL…
How do I restart MySQL? To restart the MySQL server, use the command /etc/init.d/mysql restart. The MySQL start or stop services can also be done…
What is query result cache? A result cache is an area of memory, either in the Shared Global Area (SGA) or client application memory, that…
Will the select statement return rows from a table? The SQL SELECT statement returns a result set of records, from one or more tables. A…
How do you randomly sample in SQL? Random Sampling Within Groups using SQL Create a random row number for each user_id that resets for each…
How to use Oracle data pump to export data? Oracle Data Pump Export is a utility for unloading data and metadata into a set of…