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

How To Create Unique Index On Partitioned Tables in SQL Server

dbtut May 4, 2019 MSSQL 1

In the article named “Can Not Switch The Partition On SQL Server“, we mentioned that all indexes in the partitioned table should be aligned according …

How To Find Serial Numbers of Exadata Servers and Components

dbtut May 4, 2019 ORACLE 0

The serial numbers and part codes of the compute nodes and cellnodes and components in these nodes in the Exadata are required to supply the …

Send Email To DBAs When Transaction Log Sizes Reachs the Certain Limit

dbtut May 3, 2019 MSSQL 0

Sometimes the transaction log file may grow more than normal for some reasons. For example when the transaction logs are not backed up. In the …

READ Object Privilege in Oracle 12c

dbtut May 3, 2019 ORACLE 0

The READ object privilege introduced with the 12c (12.1.0.2) version. It allows us to read a table without locking. It is used to create read-only …

Create Index On the GROUP BY Column

dbtut May 1, 2019 MSSQL 0

Before you start reading this article, I suggest you read the article “Index Concept and Performance Effect on SQL Server” for more detailed information about …

Oracle Direct NFS (dNFS)

dbtut May 1, 2019 ORACLE 0

Oracle Direct NFS (dNFS) is an optimized NFS client that provides faster and more scalable access to NFS storage in NAS storage devices. Direct NFS …

Create Index on the Order By Column(ASC,DESC)

dbtut April 30, 2019 MSSQL 0

Before you start reading this article, I suggest you read the article “Index Concept and Performance Effect on SQL Server” for more detailed information about …

impdb disable_archive_logging usage

dbtut April 30, 2019 ORACLE 0

With the disable_archive_logging parameter, which is a feature introduced with Oracle 12c, we are able to import without producing redo in a database in archivelog …

Hidden Parameters in Oracle Database

dbtut April 29, 2019 ORACLE 0

There are many hidden parameters in Oracle databases. These parameters should be changed if required by Oracle. Unconscious change of these parameters can be a …

Create Index On Join Columns

dbtut April 29, 2019 MSSQL 0

Before you start reading this article, I suggest you read the article “Index Concept and Performance Effect on SQL Server” for more detailed information about …