Useful tips for everyday
How do I change the default port in MongoDB? 1 Answer You can easily change the port number with the help of the mongodb.config file.…
Does select distinct affect performance? Yes, basically it has to sort the results and then re-processed to eliminate the duplicates. This cull could also be…
How do you resume a suspended database mirroring? To pause or resume database mirroring During a database mirroring session, connect to the principal server instance,…
Is there any GUI for PostgreSQL? pgAdmin is the de facto GUI tool for PostgreSQL, and the first tool anyone would use for PostgreSQL. It…
How to define a recursive common table expression? The following guidelines apply to defining a recursive common table expression: The recursive CTE definition must contain…
How load balancing is implemented in SQL Server? If the SQL Server instances are in multiple resource groups and regions, perform each step twice, once…
How are stored procedures identified in SQL Server? It is also relevant to recall that stored procedures reside in a database. Therefore, a stored procedure…
Do MongoDB indexes have to be unique? A unique index ensures that the indexed fields do not store duplicate values; i.e. enforces uniqueness for the…
How can use row-level security in SQL Server? Row-Level Security in SQL Server is used to restrict the users at the database level rather than…
Does serializable lock table? SERIALIZABLE – lock on a full table(on which Select query is fired). This means, B reads the data and no other…