Useful tips for everyday
How do you create a custom error message in SQL Server? Defining custom error messages To define a custom error message in SQL Server 2005,…
How do you fix Ora-00001 unique constraint violated? ORA-00001 Solution Change your SQL so that the unique constraint is not violated. Change the constraint to…
What are the buckets for database performance tuning? When it comes to database performance tuning, separating potential issues into buckets means organizing everything based on…
How do you change column values when importing csv into Dataframe? Approach Import module. Open csv file and read its data. Find column to be…
Can we disable unique index in Oracle? To disable an index, you run an ALTER INDEX command: ALTER INDEX index_name ON table_name DISABLE; You can…
What normal form is the relation in? A relation is in third normal form, if there is no transitive dependency for non-prime attributes as well…
How do I shutdown MySQL in Linux? Third, use the following command to stop MySQL Server: mysqladmin -u root -p shutdown Enter password: ******** It…
What is the use of default constraint? The DEFAULT Constraint is used to fill a column with a default and fixed value. The value will…
What is database inheritance? Inheritance enables you to share attributes between objects such that a subclass inherits attributes from its parent class. Subclasses must include…
How to enable replication in SQL Server management studio? Using SQL Server Management Studio (SSMS) On the Publication Databases page of the Publisher Properties –…