Useful tips for everyday
What are the backup methods available in Oracle? You can use logical backups to supplement physical backups. There are two ways to perform Oracle backup…
Can we use order by for 2 columns? If you want to select records from a table but would like to see them sorted according…
How do I copy files to a network drive? The plan is to run a batch file to copy a file from a network drive…
How do you decommission a SQL cluster? To remove a clustered instance of SQL Server instance From the Management Console, navigate to the Windows cluster…
Can the same database be used for both OLAP and OLTP purposes? A mixed workload database is capable of handling both OLAP and OLTP workloads…
How the size of tablespace can be increased? To Extend the Size of a tablespace You can also extend the size of a tablespace by…
What is graph modeling? Graph data modeling is the process in which a user describes an arbitrary domain as a connected graph of nodes and…
How to make MySQL high availability? I have divided the entire process of deploying the MySQL InnoDB cluster into the following steps: Map Domain Address…
How to add ANSI null and ANSI warning? Showing error as “heterogeneous queries require the ansi_nulls and ansi_warnings options to be set for the connection”…
Why is indexing used in MongoDB? Indexes support the efficient execution of queries in MongoDB. Without indexes, MongoDB must perform a collection scan, i.e. scan…