Useful tips for everyday
How do I update virtual columns? You can’t update (in SET clause of update statement) the values of virtual column. These are read only values,…
How do I stop a cluster in PostgreSQL? stop Stops the postgres(1) server of the given cluster. By default, “smart” shutdown mode is used, which…
How do I reconcile AR accounts? Reconciling Accounts Receivable Update all transactions for the period of the reconciliation. Run an aged trial balance report. Run…
Is MyISAM slower than InnoDB? “MyISAM is faster” — This is an old wives’ tale. Today, InnoDB is faster in most situations. Assuming you have…
How does normalization reduce data redundancy? Boyce Codd normal form prevents redundancies by identifying key attributes listed multiple times by overlapping key candidates. In the…
How do you change emergency mode? The emergency mode is used when the SQL Server database is in suspected status and we change to emergency…
Does DBCC Checkdb use TempDB? DBCC CHECKDB can make heavy use of tempdb, so make sure you plan for resource utilization there. Does DBCC Checkdb…
How do you store real-time data? You can use Redis as a buffer, and create a separated worker to save in bulk the data from…
What is SQL isolation? Isolation is the separation of resource or data modifications made by different transactions. Isolation levels are described for which concurrency side…
How do I create a hierarchical recursive query in mysql? Let’s create a hierarchical recursive query taking into consideration MYSQL version 8 and above. select…