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

When an object is incorrectly compiled, it is necessary to determine what this error is and to correct the error. You can view this error …

The Backup Compression feature was introduced with SQL Server 2008. We can reduce our backup sizes by selecting this option when backing up. However, while …

This error is received when trying to import a Data Pump export of the 12c r2 database to a lower version. The error content is …

With Compound Operators, we can make operations on variables more easily. For example, let’s assume that @a is a variable and we want to increase …

Index quality is a factor that directly affects all database performance. The quality of an index is measured by the rate of clustering_factor / num_rows. …

With User Defined Table Type, we can store the structure of a table. We can use the User Defined Table Typies by defining the table-valued …

If Tuning and Diagnostic Packs is installed, automatic snapshots can be created with AWR and we can get information about the database performance among the …

The Query Store is a feature that introduced in SQL Server 2016. In order to understand the Query Store, it is necessary to understand the …

OutOfMemoryError error may be received because of inadequate memory when running addnode.sh or during Oracle database installation. addnode.sh is terminated as follows when the error …

Database Engine Tuning Advisor (DTA) examines how queries are running in the database and provides us with suggestions. It has its own interface. You can …