Useful tips for everyday
What is circular dependency in database? In the world of relational databases circular references are schema structures where foreign keys relating the tables create a…
Does SELECT lock row? Yes, select locks the table until reads completes which conflicts with Insert/Delete/Updates lock mode. Generally Select should be used with WITH…
Why do union intersection and difference operations require that the relation on which they are applied be union compatible? If wedo a Union, Intersection or…
Is there a way to reduce the memory of SQL Server? Setting max server memory to the minimum value can even prevent SQL Server from…
What is the purpose of write-ahead logging? Write-Ahead Logging ( WAL ) is a standard method for ensuring data integrity. A detailed description can be…
Can a SELECT statement be deadlocked with an update? Two SELECT statements are not going to deadlock, but a SELECT can deadlock with an UPDATE.…
Can nvarchar be converted to varchar? Whether you can convert from NVARCHAR to VARCHAR depends on your data. If all the character data fits in…
How to create user accounts using MySQL create user statement? MySQL CREATE USER syntax The CREATE USER statement creates a new user in the database…
What are 3 types of SQL triggers? There are three types of triggers in SQL Server. DDL Trigger. DML Trigger. Logon Trigger. For which DDL…
Does Mongodump lock the collection? Mongdump does not lock the db. It means other read and write operations will continue normally. Actually, both mongodump and…