Useful tips for everyday
What to do when MySQL is out of disk space? Another way to perform a defragmentation operation is to use mysqldump to dump the table…
What does the partition count show? count() for each Partition ID. By doing a simple count grouped by partition id, and optionally sorted from smallest…
How do you reference a primary key? If the primary key you want to reference is made up from multiple columns, all foreign keys referencing…
How do I restore one database to another? Connect to the appropriate instance of the SQL Server Database Engine, and then in Object Explorer, click…
How do you do transactional replication in SQL Server? Configure the Publication Right-click the Replication folder and click New Publication. The publication database wizard opens,…
How does DBLink work in Oracle? Use the CREATE DATABASE LINK statement to create a database link. A database link is a schema object in…
How do I change the relationship type in access to many-to-many? Open the Edit Relationships dialog box On the Database Tools tab, in the Relationships…
How do I drop multiple columns at a time in SQL? Physical Delete To physically drop a column you can use one of the following…
Can you use coalesce in join condition? A COALESCE function returns the first non-NULL expression from a specified list. Usually, we use COALESCE as one…
Can a access database be linked to SQL Server? As a result, you can still maintain the front-end Access database with linked tables to the…