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

What is Partitioned View in SQL Server

dbtut April 3, 2019 MSSQL 0

As you know, partition is the division of large tables into small tables. For more information about Partition, please read the article “How To Create …

Replacing a Damaged Flash Disk(fmod) on Exadata

dbtut April 3, 2019 ORACLE 0

In case of a damage of the flash modules(fmod) on flash cards on Exadata cellnodes, the flash cache will not function normally and there will …

“Arithmetic overflow error converting expression to data type int.” Error When Using SUM Function

dbtut April 2, 2019 MSSQL 0

You can receive this error when you want to get a total result by using the SUM function. In order to avoid this error, you …

Replacing a Damaged Hard Disk on Exadata

dbtut April 1, 2019 ORACLE 0

You can perform the hard disk replacement on Exadata cellnodes by performing the following checks and steps. Hard Disks on the cell node are automatically …

What is Remote Diagnostic Agent (RDA)

dbtut March 30, 2019 ORACLE 0

The Remote Diagnostic Agent (RDA) is a tool provided by Oracle that collects data about your database environment and reports it as a web page. …

PostgreSQL AWR

Faruk Erdem March 29, 2019 PostgreSQL 3

In PostgreSQL, you may need to review more than one thing to analyze database or whole cluster when you encounter a problem. For example, a …

Optimizing MySQL queries where clause contains function by using Generated Columns

Shuo Wang March 29, 2019 MySQL-MariaDB 0

Description: As we know, we can’t create a function-based index on MySQL, not like PostgreSQL (https://www.postgresql.org/docs/current/indexes-expressional.html). Usually, we should avoid using functions in the where …