Useful tips for everyday
Does Oracle allow a composite key? Oracle creates an index on the columns of a unique key, so a composite unique key can contain a…
What is the maximum memory for SQL Server 2012? It’s a bummer that SQL Server 2012 Standard Edition only allows you 64GB of memory. And…
Is it good to use array in PostgreSQL? Arrays can be used to denormalize data and avoid lookup tables. A good rule of thumb for…
What does update from select do in SQL? The “UPDATE from SELECT” query structure is the main technique for performing these updates. An UPDATE query…
How do you find the difference in minutes between two date objects? To calculate the minutes difference between two dates, we should divide the diffInMilliSeconds…
Why does MySQL consume so much memory? MySQL tries to allocate more memory than available because we specifically told it to do so. For example:…
How to count data by using a total row? On the Home tab, in the Records group, click Totals. For more information about using a…
How do I get descending order in PostgreSQL? When sorting your result set in descending order, you use the DESC attribute in your ORDER BY…
How to search JSON array in MySQL? How to search JSON array in MySQL? Let’s say I have a JSON column named data in some…
How do I undo duplicates? Remove duplicate values Select the range of cells that has duplicate values you want to remove. Tip: Remove any outlines…