Useful tips for everyday
How many transactions can MySQL handle per second? The maximum theoretical throughput of MySQL is equivalent to the maximum number of fsync(2) per second. What…
What are specifications of foreign key? A foreign key is a column or group of columns in one table that contains values that match the…
How do I execute a stored procedure in SQL Agent? Expand the SQL Server Agent and right click on Jobs and click on New Job……
How do I concatenate strings in SQL Server? SQL Server CONCAT() Function Add two strings together: SELECT CONCAT(‘W3Schools’, ‘.com’); Add 3 strings together: SELECT CONCAT(‘SQL’,…
When to use SQL sum with group by? SQL SUM() function with group by. Last update on March 15 2019 07:13:38 (UTC/GMT +8 hours) SUM…
Do SQL passwords expire? Password expiration policies are used to manage the lifespan of a password. When SQL Server enforces password expiration policy, users are…
Why is my database not opening? This is another instance that may result in ‘Access database not opening’ issue. Interruption in the connection between Access…
How to select rows with the latest timestamp? I have a table with duplicate & triplicate rows – how do I select the rows that…
Is there a way to read the configuration file? There are different ways to set the values inside the configuration file and read their values,…
How do I install multiple MySQL instances on CentOS 7? multiple MySQL instance on Fedora/CentOS/Redhat/Scientific Linux 1- Create new database instance on new destination. 2-…