Useful tips for everyday
Can foreign key be updated? The foreign key relation can be created either through SSMS GUI or T-SQL. Rules for update/delete operations may be specified…
What is the best practice to configure TempDB SQL Server? First of all, unless you’re running SQL Server Express, set tempdb to be bigger than…
How do you find a row with the same value? The find duplicate values in on one column of a table, you use follow these…
How to get PostgreSQL table relation does not exist? My dump file had the command below from where things started going south. Probably remove it…
How to find all parents, children using SQL query? It will not only find Parent of children for a particular level but you can use…
Does database backup affect performance? Backups should not cause performance problems as such operations do not take locks on user objects. Which recovery model allows…
How do you overcome the lost update problem? Possible Solutions Ignore It. The simplest technique is to just ignore it, hoping it will never happen;…
How long does it take to set a primary in MongoDB? The median time before a cluster elects a new primary should not typically exceed…
What happens when RDS instance fails? The failed RDS DB instance reboots. The IP of the primary DB instance is switched to the standby DB…
Where can I find the PG Stat statement reset? This view, and the functions pg_stat_statements_reset and pg_stat_statements, are available only in databases they have been…