Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

Although passwordless ssh connection is established between compute node and cell nodes in the Exadata installation, this connection can be broken due to some problems. …

This is because the user account that the SQL Server service is running on is not authorized in the MSSQL Registry files. Solution -> Run …

Gaps occur in the blocks due to deletion operations in the tables. These spaces remain as wasted space. These spaces should be determined and shrink …

With SQL Server 2016, support for automatic update statistics in Memory Optimized Tables is available. If the database is created with compatibility level 130, nothing …

Oracle attempts  to put a lock on the table with the foreign key if a change is made to the main table with the primary …

When I tried to open SQL Server 2017 Configuration Manager, I received an error like the following. My problem is solved when I follow the …

Enqueues are shared memory structures that serialize access to database resources.(locks) They can be associated with a session or transaction. HW (high water mark) is …

When we create a database through SQL Server Management Studio version 17.3 and right click on it and click properties, we receive this error. To …

An active request represents a client- or application-centric view of I / O requests processed by the cell node. You can view active requests on …

We are able to configure some critical options set at instance level, such as MAXDOP, at the database level with Database Scoped Configurations feature of …