Useful tips for everyday
Does Postgres have a query cache? PostgreSQL Query Cache, a new open source software, which enables to improve query performance extremely (10x~100x) by caching query…
How do I split data into two columns in Excel? Try it! Select the cell or column that contains the text you want to split.…
Are MariaDB materialized views? MariaDB does not support materialized views natively, but you can easily create them with a tool called Flexviews. It uses MariaDB’s…
Which is the best way to combine multiple updates into one query? MySQL allows a more readable way to combine multiple updates into a single…
How do I grant grants in MySQL? To grant a privilege with GRANT , you must have the GRANT OPTION privilege, and you must have…
What are the measure of the fact table? Fact tables contain the content of the data warehouse and store different types of measures like additive,…
Is SQL Server 2008 end of life? If you are not already aware, SQL Server 2008 and SQL Server 2008 R2’s extended support ended on…
Can you find alternative successful solutions for concurrent update / insert? Mythbusting: Concurrent Update/Insert Solutions – Busting myths this week with an excellent look at…
What happens to the Order of the columns in an index? Altering the index in order of selectivity doesn’t affect either the expected number of…
How is role based access implemented? 5 Steps to Implement Role-Based Access Control Create a mapping of roles to resources from step 1 such that…