Useful tips for everyday
How do I rollback an update query in SQL Server without backup? In this case, you can use the following steps: Right click on database…
What is the use of shrink database in SQL Server? The Shrink Database task reduces the size of SQL Server database data and log files.…
Do read replicas improve performance? Amazon RDS Read Replicas provide enhanced performance and durability for RDS database (DB) instances. They make it easy to elastically…
What is functional dependency preserving? The dependency preservation decomposition is another property of decomposed relational database schema D in which each functional dependency X ->…
How do you navigate to previous record in access? The record navigation buttons are available at the bottom of the table or form. Go to…
Can CTE be used in views? A Common Table Expression, also called as CTE in short form, is a temporary named result set that you…
What is sync metadata database? The Sync Metadata Database contains the metadata and log for Data Sync. The Sync Metadata Database has to be an…
How do I insert a NULL value in a timestamp column? In order to allow a TIMESTAMP to be nullable, create it using the NULL…
Is it good practice to use a surrogate key? The only good thing in surrogate keys is that you don’t have to repeat the actual…
How to connect to PostgreSQL from another network? I can remotely connect to it within the network using the computer name, so i know that…