Useful tips for everyday
How do I start MariaDB command line? The simplest way to start database from the command line is: Go to the directory where mariadbd.exe is…
How do you get a non-matching record? SELECT B. Accountid FROM TableB AS B LEFT JOIN TableA AS A ON A.ID = B. Accountid WHERE…
How can you tell who created a table in SQL Server? To see the table created date and time from properties window: In the Object…
How do I check backup integrity? To check the integrity of the backup file, periodically retrieve your backup file, open it on a separate system,…
Are SQL licenses perpetual? Even if your license is perpetual and legally speaking you are allowed to keep the product forever, it may still be…
How are survey questions stored in database? Database design for a survey [closed] Create a giant table which contains the answers for each survey submission.…
How to copy a Postgres database to a remote server? For example, to copy the dvdrental database from the localhost server to the remote server,…
What is Btree in PostgreSQL? PostgreSQL B-Tree indexes are multi-level tree structures, where each level of the tree can be used as a doubly-linked list…
What causes SQL deadlock? A deadlock occurs when 2 processes are competing for exclusive access to a resource but is unable to obtain exclusive access…
How to enable read-only access to secondary availability group replica? A stand-alone server instance, COMPUTER03\\HADR_INSTANCE, is specified to host the new availability replica. This replica…