Useful tips for everyday
How do I delete a database in Oracle SQL Developer? To delete a connection (that is, delete it from SQL Developer, not merely disconnect from…
How do I insert data from one server to another in SQL Server? Solution Creating a Linked Server to the target instance on the source…
Is it possible to upgrade PostGIS to 2.1? Upgrading PostGIS. To upgrade PostGIS, you first have to install the latest binaries and then upgrade each…
What is workload group? A workload group serves as a container for session requests that are similar according to the classification criteria that are applied…
Why out of memory error occurs in Java? OutOfMemoryError exception. Usually, this error is thrown when there is insufficient space to allocate an object in…
Can BitLocker be used on servers? It’s supported to use BitLocker encryption on file server. You can refer to BitLocker: How to deploy on Windows…
Can we create index on view in Postgres? CREATE INDEX constructs an index on the specified column(s) of the specified relation, which can be a…
How to check memory target in Oracle Database? If your database does not use automatic memory management, consult the Oracle Database Administrator’s Guide to find…
What are the differences between hash join merge join and nested loops? Difference between Nested Loop Join and Hash Join Nested Loop Join : This…
How do I create a web app database? In order to create your new online database, go to your database control panel and click on…